> -----Original Message----- > From: Pushpinder Singh Garcha [mailto:[EMAIL PROTECTED] > Sent: 30 June 2003 19:10 > > Can someone tell me what is wrong with the following querys ? I am > pretty sure its got something to do with the quotes around $_POST[] > variables. > > $sql1 = "SELECT * from `admin` where `admin`.user = > '"$_POST['validuser']"' AND `admin`.pwd = '"$_POST['password']"'"; > > $sql1 = "SELECT * from `admin` where user = "$_POST['validuser']" AND > pwd = "$_POST['pass']"";
Too many quotes, not enough curly braces: $sql1 = "SELECT * from `admin` where user = '{$_POST['validuser']}' AND pwd = '{$_POST['pass']}'"; Cheers! Mike --------------------------------------------------------------------- Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning & Information Services, JG125, James Graham Building, Leeds Metropolitan University, Beckett Park, LEEDS, LS6 3QS, United Kingdom Email: [EMAIL PROTECTED] Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php