now rand() not working...??? help...

vaska

this is nuts...i'm having all the small problems this morning...

random is not working...what am i missing this time (if anybody knows)?

// color info

$query_bg = mysql_query ("SELECT colname,colid FROM colors ORDER BY RAND() LIMIT 1 " ) or die ("Unexpected error for MySQL database");
$row_bg = mysql_fetch_array($query_bg);

it IS outputting the first record every time...and yeah, i have more than one record in there...haha...doi...

merci beaucoup in advance...jv

ereptur

doesn't rand accept a seed as an arguement?

hand

omit the "LIMIT 1" statement

// color info

$query_bg = mysql_query ("SELECT colname,colid FROM colors ORDER BY RAND()" ) or die ("Unexpected error for MySQL database");
$row_bg = mysql_fetch_array($query_bg);

vaska

hmmm...really stumped...i'm finally get back around to this little problem...

i omitted LIMIT 1...still doesn't work...

anybody have any thoughts about this?

thanks...jv