SELECT t.ownerID, t.last_update, o.teamname
FROM teampages t, owners o
WHERE t.ownerID = o.ownerID
ORDER BY t.last_update DESC LIMIT 10
-----Original Message-----
From: Jeff Lewis [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 05, 2001 5:00 PM
To: [EMAIL PROTECTED]
Subject: [PHP] PHP/mySQL Query
I fought the urge to post this here but have to :(
I have two tables named like this:
owners
-ownerID
-teamname
-more fields
teampages
-ownerID
-bio
Anyway, I'm doing a select on the database like this: select ownerID,
last_update FROM teampages ORDER BY last_update DESC LIMIT 10
The thing is, I want to get the team name from the other table as well. Can
anyone help me out?
Jeff
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
