Random post fra mysql database

mysql_query("SELECT * FROM banner ORDER BY RAND() LIMIT 1");

den udskriver ikke random, her er den kode jeg bruger:

<?php
require_once("./includes/global/functions.php");
connect_db();
select_db();
$today = date("Ymd");
$sql = "SELECT * FROM ".$or_dbprefix."_banners ORDER BY RAND() LIMIT 1";
$res = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($res) or die(mysql_error());
$banner_title = $row["title"];
$banner_url = $row["url"];
$banner = $row["banner"];
$expd = $row["expire_date"];
$year = substr($expire_date,0,4);
$month = substr($expire_date,4,2);
$day = substr($expire_date,6,2);
$banner_dat = $year.$month.$day;

if($today < $banner_dat) {
echo("<a href=\"$banner_url\" target=\"_blank\"><img src=\"$banner\" alt=\"$banner_alt\" border=\"0\"></a>");
} else {
echo("<a href=\"$or_banner_url\" target=\"_blank\"><img src=\"$or_banner\" alt=\"$or_banner_alt\" border=\"0\"></a>");
}

?>

hvad kan der være galt??

prøv dette:

$sql = "SELECT * FROM ".$or_dbprefix."_banners, RIGHT(RAND(), 4) AS r ORDER BY r DESC LIMIT 0,1";

$row = (mysql_fetch_assoc($res));

så får jeg dette fejl:
You have an error in your SQL syntax near 'RIGHT(RAND(), 4) AS r ORDER BY r DESC LIMIT 0,1' at line 1

ups

$sql = "SELECT *, RIGHT(RAND(), 4) AS r FROM ".$or_dbprefix."_banners ORDER BY r DESC LIMIT 0,1";

moreless: dit svar virkede tak, skriv et svar så får du points.

okay takker

no problemo :)