RE: [PHP] PHP/mySQL Query
| From: | Chadwick, Russell | Date: | Fri, 06 Jul 2001 00:13:32 +0000 |
| Subject: | RE: [PHP] PHP/mySQL Query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-56409@lists.php.net to get a copy of this message | ||
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:jeff@hyrum.net]
Sent: Thursday, July 05, 2001 5:00 PM
To: php-general@lists.php.net
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