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