From Max to Random

[frank_solo]

I would like this to select a random record from MySQL database table.

How could I do this?

 

<?php
require_once("../includes/db_config.php");

$db = mysql_connect(DB_SERVER, DB_USER, DB_PASS);

if($db) {
	if(mysql_select_db("", $db)) {
		$sql = "SELECT id, imageurl1, title, county, rent, description FROM apartments WHERE date_created = (SELECT MAX(date_created) FROM apartments)";
		$result_set = mysql_query($sql, $db);
		if($result_set && mysql_num_rows($result_set) == 1) {
			$latest_listing = mysql_fetch_assoc($result_set);
		}
	}
}
?>

[Porl123]

Add "ORDER BY RAND() LIMIT 1"

[frank_solo]

Where do I add that statement?

[Porl123]

$sql = "SELECT id, imageurl1, title, county, rent, description FROM apartments WHERE date_created = (SELECT MAX(date_created) FROM apartments) ORDER BY RAND() LIMIT 1";
$result_set = mysql_query($sql, $db);
if($result_set && mysql_num_rows($result_set) == 1) {
$latest_listing = mysql_fetch_assoc($result_set);
}

[frank_solo]

Thank you Porl123!

[Porl123]

No probs

[frank_solo]

Wait it is not working. Maybe because "MAX(date_created)"?

[Pikachu2000]

Yes. You're trying to get a random record from a results set that only contains one record. Obviously, the "random" record will always be the only one that was selected. Also, see the link in my signature for reasons why 'ORDER BY RAND()' isn't a good idea, and suggestions on better ways to do it.