php random number

[Jiraiya]

i have a script that generates a random number

<?php
echo (rand(1,10));
?>

my question is how do i set a mysql variable to equal that random number all in one script?

[Maq]

Do you mean something like:

 

$var = rand(1, 10);
$sql = "SELECT * FROM table WHERE id = '$var'";
mysql_query($sql) or die(mysql_error());

[Jiraiya]

yea kinda i have the variable set to "0" on default so i guess it would be an update mabey?

[Maq]

yea kinda i have the variable set to "0" on default so i guess it would be an update mabey?

 

Maybe...  I have no clue what you're trying to accomplish here.

[Jiraiya]

here is the code

it displays a random number but doesn't update the variable

 

 

$username = $_COOKIE['ID_my_site']; 
$sql = mysql_query("SELECT * FROM users WHERE username = '$username'") or die(mysql_error());

echo (rand(1,10));
$var = rand(1, 10);
$sql = "SELECT * FROM users WHERE number = '$var'";
mysql_query($sql) or die(mysql_error());



?>

[phil88]

I still don't understand what you're trying to do... what are you trying to update? and with what?

[Jiraiya]

im trying to set the random number that is generated to be set as the value of variable "number"

[premiso]

$sql = "UPDATE users SET number = '$var' WHERE username = '$username'";

 

You said the answer yourself....

[Maq]

Just a guess  ???

 

$username = $_COOKIE['ID_my_site'];
$var = rand(1, 10);
$sql = "UPDATE users SET number = '$var' WHERE username = '$username'";
echo "QUERY=> " . $sql;
mysql_query($sql) or die(mysql_error());