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



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to