How do I insert a page variable into SQL please?
Posted: Wed Jul 28, 2004 2:11 am
Please bear with me I am a newbie
I have a variable [MembNo ] carried forward from a form see below:
Your Membership Number is <?php echo $_POST["MembNo"]; ?>.<br>
I want to retrieve Firstname from the database and insert it into the page
$sql="SELECT Firstname FROM Officerquery WHERE MembershipNo = "$_POST["MembNo"]"";
$rs=odbc_exec($conn,$sql); if (!$rs)
What is the correct syntax for 'WHERE MembershipNo = 'please
I have a variable [MembNo ] carried forward from a form see below:
Your Membership Number is <?php echo $_POST["MembNo"]; ?>.<br>
I want to retrieve Firstname from the database and insert it into the page
$sql="SELECT Firstname FROM Officerquery WHERE MembershipNo = "$_POST["MembNo"]"";
$rs=odbc_exec($conn,$sql); if (!$rs)
What is the correct syntax for 'WHERE MembershipNo = 'please