How do I make a varible unique...

[maxudaskin]

How do I make a variable unique to a set in a database?

 

This is what I got so far... Should I change anything?

$id = $_GET["apps"];
$hub = $_GET["hub"];
$huba = $hub/1000;
$rand = rand(001,999);
$temppid = $hub+$rand;
$result = mysql_query("SELECT pid FROM `users` WHERE `pid`='{$temppid}'");
if($result==$temppid)
{
$pidcheck = 1;
}
else
{
$pidcheck = 0;
}

if($pidcheck = 0)
{
$pid = $temppid;
}
else
{

}

[RichardRotterdam]

What is it exactly that you want to be unique? A database record?

[maxudaskin]

I want $pid to be unique so it can be added to the database and be the only of that number.

 

SCRIPT UPDATE:

 

$id = $_GET["apps"];
$hub = $_GET["hub"];
$huba = $hub/1000;
$rand = rand(001,999);
$temppid = $hub+$rand;
$result = mysql_query("SELECT pid FROM `users` WHERE `pid`='{$temppid}'");
if (mysql_num_rows($result) == 1)
{
$pidcheck = 1;
}
else
{
$pidcheck = 0;
}
echo $pidcheck;