Re: [PHP] Quick SQL Question

> 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

Re: [PHP] Quick SQL Question

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.zon

Re: [PHP] Quick SQL Question

> I'm using the "ORDER BY RAND() LIMIT 0,1" to give be a random record from a > recordset but it seems like it puts a real heavy load on the server. Is > there a better way to pull a random record from a database? I used order by rand() with MySQL quite often and do not notice any load issues wi

[PHP] Quick SQL Question

I'm using the "ORDER BY RAND() LIMIT 0,1" to give be a random record from a recordset but it seems like it puts a real heavy load on the server. Is there a better way to pull a random record from a database? Thanks -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http:/