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
Subject: [PHP] PHP/mySQL Query

I fought the urge to post this here but have to :(

I have two tables named like this:

-more fields


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?


PHP General Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to