[phpfreek]

Hello;
i am looking for a code that will generate a number composed out of 6 numbers(xxxxxx), the number must be random and unique ...

I don't want to use auto-increment ... i just want a php script that will generate a 6 number number that is unique in the hole database (no field in the database is equal to this number), and then store it in a given field in a given table ...


Is this possible using only php codes ?

If someone thinks it's possible and can code it, please give me the code, thank you in advance.
Best Regards;
PHPFREEK

[Nico]

Yes, me again, lol.

Untested but should work with a little modification in the query.

PHP Code:

function generate_unique_id()

{

    $num = '';



    for ($i = 0; $i < 6; $i++)

    {

        $num .= rand(0, 9);

    }

    

    $check = mysql_query("SELECT number FROM table WHERE number = ". $num) OR die( mysql_error() );

    

    if (mysql_num_rows($check) == 0)

    {

        return $num;

    }

    else

    {

        return generate_unique_id();

    }

}



$unique_number = generate_unique_id(); 

[phpfreek]

OMG ... are you searching for everything i post and help me with it ? ... or is it coincidence ?

Anyway, i have edited the script to be like this :

PHP Code:

<?php 

session_start();

include("config.php");

$usernamee=$_SESSION['username'];

function generate_unique_id() 

{ 

    $num = ''; 



    for ($i = 0; $i < 6; $i++) 

    { 

        $num .= rand(0, 9); 

    } 

     

    $check = mysql_query("SELECT number FROM $usernamee WHERE tickets = ". $num) OR die( mysql_error() ); 

     

    if (mysql_num_rows($check) == 0) 

    { 

        return $num; 

    } 

    else 

    { 

        return generate_unique_id(); 

    } 

} 



$unique_number = generate_unique_id();



?>

Now this means that the table's name will be the username, and the field where the code must check if there is a number like it or not s called "tickets".

What your code does is generate the number and check if it exists (then it will start the process all over again).
But if the number doesn't exist, your code doesn't store the number in the field ... there's a query missing ... am i right or wrong ??

Waiting your reply.
Best Regards And thank again;
PHPFREEK

[phpfreek]

still waiting ...

[Nico]

Try this.

PHP Code:

<?php 

session_start();

include("config.php");

$usernamee=$_SESSION['username'];

function generate_unique_id() 

{ 

    $num = ''; 



    for ($i = 0; $i < 6; $i++) 

    { 

        $num .= rand(0, 9); 

    } 

     

    $check = mysql_query("SELECT tickets FROM $usernamee WHERE tickets = ". $num) OR die( mysql_error() ); 

     

    if (mysql_num_rows($check) == 0) 

    { 

        mysql_query("INSER INTO ". $usernamee ." (tickets) VALUES (". $num .")") OR die( mysql_error() );

        return $num; 

    } 

    else 

    { 

        return generate_unique_id(); 

    } 

} 



$unique_number = generate_unique_id();



?>

[phpfreek]

Hey bro, thanks for your reply

i ttried the code u gave me, below is the phrase that appeared whn i executed it :

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE tickets = 781930' at line 1"

Why is this ??

Thanks again ...
PHPFREEK

[UnrealEd]

instead of this:

PHP Code:

$check = mysql_query("SELECT tickets FROM $usernamee WHERE tickets = ". $num) OR die( mysql_error() ); 

try this:

PHP Code:

$check = mysql_query("SELECT tickets FROM $usernamee WHERE tickets = '". $num . "'") OR die( mysql_error() ); 

this should do it,
UnrealEd

[Nico]

Integers don't need quotes usually. That's why I left them out.

[jfulton]

It will need quotes if it's a string (Char/Varchar) though. Like the difference between '0013009' and 13009.

[phpfreek]

Thanks for helping me out guys, but anther error is beeing displayed

Here is my script now :

PHP Code:

<?php  

session_start(); 

include("config.php"); 

$usernamee=$_SESSION['username']; 

function generate_unique_id()  

{  

    $num = '';  



    for ($i = 0; $i < 6; $i++)  

    {  

        $num .= rand(0, 9);  

    }  

      

    $check = mysql_query("SELECT tickets FROM $usernamee WHERE tickets = '". $num . "') OR die( mysql_error() );  

      

    if (mysql_num_rows($check) == 0)  

    {  

        mysql_query("INSER INTO ". $usernamee ." (tickets) VALUES (". $num .")") OR die( mysql_error() ); 

        return $num;  

    }  

    else  

    {  

        return generate_unique_id();  

    }  

}  



$unique_number = generate_unique_id(); 



?>

And here is the error being displayed :

Parse error: parse error, unexpected T_STRING in C:\Documents and Settings\Administrator\Desktop\xampplite\htdocs\xa mpp\test\FEDEX\change2.php on line 18

Will this script ever work ???

Thanks again