Re: Quick SQL Question
| From: | Vernon | Date: | Wed, 18 Jun 2003 01:27:26 +0000 |
| Subject: | Re: Quick SQL Question | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-151924@lists.php.net to get a copy of this message | ||
Here it is:
SELECT penpals.username, penpals.zoneid, penpals_photos.album,
penpals_photos.rating, zones.zone_id, zones.zone_code,
penpals_photos.filename, penpals.city
FROM penpals, penpals_photos, zones
WHERE penpals.username = penpals_photos.album AND penpals_photos.rating !=
'X' AND penpals.zoneid = zones.zone_id
ORDER BY RAND() LIMIT 0,1