Directing Program Flow

[mrgrammar]

I have a page that has to generate a 9-digit order number and then check the db (MySQL) to see if it exists. If it already exists, it needs to generate a new order number and recheck until a unique number is created.

//MARKER

$rantruckorderid = rand(000000000,999999999);

$chkorderid = "select truckorderid from truckorders where truckorderid=".$rantruckorderid;
$chkresult = mysql_db_query($database, $chkorderid);
$foundcount = mysql_num_rows($chkresult);

if ($foundcount == 0)
{
print "<h1>Continue</h1>";
}
elseif ($foundcount == 1)
{
print "<h1>Regenerate number.</h1>";
}

In the example above, if $foundcount returns rows then I need to generate a new number. Is there a way to send the code back to //MARKER to rexecute until $foundcount returns no rows?

Is there a better way to generate a unique order number?

Brian

[Natty_Dreadlock]

try something like this:

do 
{
$rantruckorderid = rand(000000000,999999999); 

$chkorderid = "select truckorderid from truckorders where truckorderid=".$rantruckorderid; 
$chkresult = mysql_db_query($database, $chkorderid); 
$foundcount = mysql_num_rows($chkresult); 

if ($foundcount == 0) 
{ 
print "<h1>Continue</h1>"; 
} 
elseif ($foundcount == 1) 
{ 
print "<h1>Regenerate number.</h1>"; 
} 
} while ($foundcount != 0)

hth

[mrgrammar]

I should have thought of that.

You know, ya gotta hate it when an answer is so obvious but you don't see it.

Thank you very much! 🙂

Brian

[Natty_Dreadlock]

not a problem, it took me some time to get the idea of while-loops when i started programming c and php.