Hi,

could someone teach me how to random create a 10 digit number, and check to see if if exists in Mysql database field. if it does exist do a loop, if it doesn't, write to the DB.

Thanks!!

Why does it have to be random?

You can do an auto-increment on the field.

Create table with auto increment field. INT data type, 10 length.

ALTER TABLE table_name AUTO_INCREMENT = 999999999;

The next insert will be a 10 digit number and each subsequent will increment 1 from that one.

hth,
Rich


:::::::::::::::::::::::::::::::::
Smiling Souls
http://www.smilingsouls.net
:::::::::::::::::::::::::::::::::

Also, should have mentioned this before, but the query I provided just sets the integer value of the AUTO_INCREMENT field, it doesn't give the field itself AUTO_INCREMENT capability.

Here's an example of the CREATE TABLE query, which will set the AUTO_INCREMENT value with the creation of the table.

CREATE TABLE `submissions` (
  `submission_id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL default '0',
  `date` text NOT NULL,
  `category_id` int(11) NOT NULL default '0',
  `title` text NOT NULL,
  `body` mediumtext NOT NULL,
  `permission` int(1) NOT NULL default '0',
  `lastaccesstime` timestamp(14) NOT NULL,
  PRIMARY KEY (`submission_id`)
) TYPE=MyISAM AUTO_INCREMENT=999999999 ;

: )
Rich

:::::::::::::::::::::::::::::::::
Smiling Souls
http://www.smilingsouls.net
:::::::::::::::::::::::::::::::::

Well, the largest 4-byte integer you can store is 4294967295, so that limits the upper bound on your 10-digit numbers.

use rand() to generate numbers. You can specify an upper and lower bound. You can also use mt_rand() to do this -- many people prefer mt_rand over rand().


<?php

// connect to db here

do
{
    $num = mt_rand(1000000000, 4294967295);
    $result = mysql_query("SELECT count(*) FROM table WHERE col='$num'");
    if (! $result)
    {
        die("Query failed: MySQL said: " . mysql_error());
    }

    $count = mysql_result($result, 0);
} while ($count > 0);

mysql_query("INSERT INTO table (col) VALUES ('$num');


Does this make sense? If not, read about do..while loops here:

 http://www.php.net/do.while

Take care,

Nik
http://www.bigaction.org/

Hi Nikolai!

Well, that seemed to work, despite an error
<?php require_once('includes/config.php');

do
{
    $num = mt_rand(1000000000, 4294967295);
    $result = mysql_query("SELECT * FROM random WHERE nummer='$num'");
    if (! $result)
    {
        die("Query failed: MySQL said: " . mysql_error());
    }

    $count = mysql_result($result, 0);
} while ($count > 0);

mysql_query("INSERT INTO random (nummer) VALUES ('$num')");

?>

the red line produces the following err:

Warning: Unable to jump to row 0 on MySQL result index 12 in /var/www/html/random.php on line 22

the rest is working fine, Thanks!

HammR

Look more closely at your code -- you didn't copy my query correctly.

I select the _NUMBER_ of rows where the id field matches the number. You select ALL the rows where the id field matches the number. This is a huge difference, since my query guarantees a single result row with a single result column.

Your query might not return ANY rows, which is why mysql_result() is choking -- you can't select a value from a nonexistent row.


Take care,

Nik
http://www.bigaction.org/

Well, its OK now, didn't know about the count(*) stuff :D

Thanks anyway!

Regards

HammR

Hi,

I am using php and mysql on Windoews 2000.
I have a problem storing a newly generated alphanumeric random number in a database table. I have the folowing code:

function rand1($length)
{
$Random = srand((double)microtime()*1000000);

$data = "AbcDE123IJKLMN67QRSTUVWXYZ";
$data .= "aBCdefghijklmn123opq45rs67tuv89wxyz";

for($i = 0; $i < $length; $i++)
{
$Random .= substr($data, (rand()%(strlen($data))), 1);
}

echo $Random;
}
rand1(10);

$TodaysDate = date("Y-m-d h:m:s");

$insert = "insert into tickettbl (TicketNo, RecDate)
    values ('$Random', '$TodaysDate')";

$result = mysql_query($insert);

if ($result)
echo "Entered";


Can anybody help me. I know it is something so simple i just can't figure it out.

Thanks in advanced,

Scoobie

add this and tell me what error you are getting, we might be able to track down more details this way:

$result = mysql_query($insert) or die(mysql_error());

 i get this error: Duplicate entry '' for key 2

i have set ticketNo column to unique