|
Posted by Kim Andrι Akerψ on 12/27/06 06:24
hackajar@gmail.com wrote:
> This works too:
>
> $random=rand(1,5);
> $query="SELECT Message FROM <database>.random_quote WHERE
> MessageID=$random"; //Don't forget to include your database!
> $message = mysql_result(mysql_query($query),0) or die(mysql_error());
Or even better:
$query = "SELECT Message FROM random_quote ORDER BY RAND() LIMIT 1";
$message = mysql_result(mysql_query($query),0) or die(mysql_error());
--
Kim AndrΓ© AkerΓΈ
- kimandre@NOSPAMbetadome.com
(remove NOSPAM to contact me directly)
Navigation:
[Reply to this message]
|