spaceman12 Posted January 1, 2011 Share Posted January 1, 2011 $loc="SELECT * FROM table WHERE username='a', id='1' AND uin='123'"; $get=myspl_query($loc) or die(mysql_error()); Please somone tell me the right command as how to use multiple AND in mysql query. Thanks Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted January 1, 2011 Share Posted January 1, 2011 WHERE `field1` = 'value1' AND `field2` = 'value2` AND `field3` = 'value3', etcetera. Quote Link to comment Share on other sites More sharing options...
spaceman12 Posted January 1, 2011 Author Share Posted January 1, 2011 thank you so much Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.