flemingmike Posted October 12, 2010 Share Posted October 12, 2010 hello, im trying to figure out how to have multiple where's. $result3 = mysql_query("SELECT * FROM customer WHERE customer = '$customer'"); sometimes there are 3 customers with the same $customer. can i add to that line WHERE contact = '$contact?'; Quote Link to comment Share on other sites More sharing options...
BlueSkyIS Posted October 12, 2010 Share Posted October 12, 2010 are you looking for AND? $result3 = mysql_query("SELECT * FROM customer WHERE customer = '$customer' AND contact = '$contact'"); Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted October 12, 2010 Share Posted October 12, 2010 $result3 = mysql_query("SELECT * FROM customer WHERE customer = '$customer' AND `another_field` = '$another_value' AND `etc` = '$etc'"); Quote Link to comment Share on other sites More sharing options...
flemingmike Posted October 12, 2010 Author Share Posted October 12, 2010 thanks guys. 45min on google and 45 sec on phpfreaks. 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.