|
where does $row get set? it look like you need to fill $row with your data. So somthing like this:
[php]
<?PHP
$sql = "SELECT * FROM listings ORDER BY RAND() LIMIT 1";
$result = @mysql_query($sql, $connection) or die(mysql_error());
$row = mysql_fetch_object($result);
?>
</head>
<body>
<?PHP
echo $row->mls;
?>
[/php]
try that. i haven't worked that much with MySQL, but it should work for you. I could be wrong, though, since you might have set $row above the code that you posted.
__________________
Profanity is the one language that all programmers understand.
Check out my Blog <---updated Nov 30 2007!
|