[SOLVED] add random numbers in MySQL ?

[plodos]

<?php
session_start();
include("dbconfig.php");
if (!$_SESSION['loggedIn']) 
{
header("location:login.php"); 
die ();
}
else
{ 
$id = $_GET['id'];

function generateRandomString($length = 10, $letters = '1234567890')
  {
      $s = '';
      $lettersLength = strlen($letters)-1;
     
      for($i = 0 ; $i < $length ; $i++)
      {
      $s .= $letters[rand(0,$lettersLength)];
      }
     
      return $s;
  }

$a = generateRandomString();
echo $a;

$sql = "INSERT INTO random (id,r) VALUES ('$id', '$a')";
//unset($a);
//echo $a;
$result = mysql_query($sql);
if($result == 1)
{
echo " OK";
}else {echo "not okey";}

}
?>

 

this code is repeating the data like

id    random_number

1  2147483647

1 2147483647

1 2147483647

1 2147483647

1 2147483647

1 2147483647

2 2147483647

I used unset() function to forget the random number but it is not working?

How can I solve the problem?

 

[Mchl]

2147483647 is maximum value of 32bit signed integer. What type is r column in your table?

[plodos]

this is my dbase table for random numbers

CREATE TABLE random (   
   id INT NOT NULL,
   r INT(10),
);

[Mchl]

Since 2147483647 is maximum value you can store in INT column, whatever larger value is cut down to this. Use BIGINT to store larger numbers.

 

http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

[plodos]

thanks for BIGINT, thats solve the problem

[Mchl]

Btw:

You can use mysql's RAND() function.

 

INSERT INTO random (`id`,`r`) VALUES ('$id',FLOOR(10000000000*RAND()))