RE: [PHP] PHP/mySQL Query....
| From: | King, Justin | Date: | Thu, 19 Jul 2001 17:46:24 +0000 |
| Subject: | RE: [PHP] PHP/mySQL Query.... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-58759@lists.php.net to get a copy of this message | ||
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