Rand help

[Vivid Lust]

Why doesnt this work? :s

<?php
//Connect and slecets database
$query = mysql_query( "SELECT MAX(id) FROM banner" )
or die(mysql_error());
$rand=rand(1,.$query.);
header('Location:http://imgsurf.wsnw.net/banner.php?id='.$rand.);
exit ();
?>

 

Thanks!

[PHP_PhREEEk]

Remove the dots...

 

<?php
$rand=rand(1,$query);

 

Err, wait, that's only a Resource ID there.. you'll need to fetch the row first before you can use it in rand()

 

PhREEEk

[papaface]

For a start

$rand=rand(1,.$query.);

should be

$rand=rand(1,$query);

 

But the actual way you're doing it wont work.

Remove the exit;

And look into how you get values from mysql.

[asmith]

as all other said .

$result = mysql_fetch_array($query);

$rand=rand(1,$result[0]);

 

note that $result is an array.