RE: [PHP] PHP/mySQL Query....

Whoops.. do SELECT DISTINCT -Justin -----Original Message----- From: "Jeff Lewis" <jeff@hyrum.net> Sent: Thursday, July 19, 2001 1:08 PM To: King, Justin; php-general@lists.php.net Subject: Re: [PHP] PHP/mySQL Query.... Yes but for the first query all I want to do is list the locations and not multiple times.... Jeff ----- Original Message ----- From: "King, Justin" <KingJ@superior.k12.wi.us> To: <php-general@lists.php.net> Sent: Thursday, July 19, 2001 1:46 PM Subject: RE: [PHP] PHP/mySQL Query.... I'm assuming you're trying to join them and show resumeID also with this SELECT r.resumeID,r.userID,u.location FROM resumes r,users u WHERE r.userID=u.userID; -----Original Message----- From: "Jeff Lewis" <jeff@hyrum.net> Sent: Thursday, July 19, 2001 12:45 PM To: php-general@lists.php.net Subject: [PHP] PHP/mySQL Query.... Ok, using PHP and mySQL have two tables that look something like this; Table 1 (users): userID location Table 2 (resumes): resumeID userID I am trying to form a query to pull all the locations and list them on the page. While I could only just select from the users one I do want to be able to pull up the resumes as well. What is the best query for this? Jeff -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net