[Resolved] Select query dont work as expected

TheIceman5

i have "SELECT * FROM tbltips ORDER BY RAND() LIMIT 1"

it will display different tips every time the page is refreshed, but its stuck on tip number 1 when on the webserver but it works fine on my computers webserver.

anyone got ideas why this is so?

kevinsequeira

might seem an obvious question but do the db on both the servers have more than one record ?

reg
kevin

TheIceman5

yeah they are an exact mirror, that was the first thing i checked.

kevinsequeira

does this happen when u run the query directly in the db or thru php ??

if its in php, then post the code

reg
kevin

TheIceman5

heres the code i use in the page, works on local host but not on webserver, also if you put the SQL in phpadmin on the webserver it also returns only the first record no matter how many times you execute it, everything works fine on loacl host on my computer though.

$agasql->set_sql("SELECT * FROM tbltips ORDER BY RAND() LIMIT 1");
$agasql->set_qryid("2");
$query = $agasql->sql_execute();

if($query){
$tip = $agasql->sql_fetch_array($query);
}

echo $tip["tip_Desc"];

it display the first record in the database only

TheIceman5

anyone?

TheIceman5

yeah dont worry, i worked it out, its a problem with mysql itself and not my coding.