اضافه کردن ای دی منحصر بفرد به دیتابس

[mirmohsen]

سلام. کد زیر رو مشاهده کنید.


طبق این کد به دیتابس سه مقدار adress,score,send اضافه میشه. میخام یهid منحصربفرد هم به دیتابس اضافه بشه به هر ردیف.چه باید بکنم.لطفا کمک کنید

$address=$_GET['address'];
if($address=='' || $address==' '){$address="unknown";};
mysql_connect('localhost','root','');
mysql_select_db('pop');
mysql_query("SET NAMES 'utf8'");


$result = mysql_query("SELECT address FROM users WHERE address='$address'");
$number = mysql_num_rows($result);
if($number==1){
$go = mysql_query("SELECT address FROM users WHERE score>0 and address<>'$address' and address<>'unknown' order by rand()");
$data=mysql_fetch_array($go);
$input=$data;
$rand_keys = array_rand($input, 2);
$numberd=mysql_num_rows($go);
if($numberd>=1){
$addr=$input[$rand_keys[0]];

mysql_query("UPDATE `users` SET score =score + 1 where address = '$address';");
mysql_query("UPDATE `users` SET sent =sent + 1 where address = '$addr';");
mysql_query("UPDATE `users` SET score =score - 1 where address = '$addr';");
echo '<script>self.parent.location="http://';echo $addr;echo'"</script>';

}else{
mysql_query("UPDATE `users` SET score =score + 1 where address = '$address';");
echo '<script>self.parent.location="http://localhost"</script>';
};

}else{

$go = mysql_query("SELECT address FROM users WHERE score>0 and address<>'$address' and address<>'unknown' order by rand()");
$data=mysql_fetch_array($go);
$input=$data;
$rand_keys = array_rand($input, 2);
$numberd=mysql_num_rows($go);
if($numberd>=1){
$addr=$input[$rand_keys[0]];
mysql_query("INSERT INTO users VALUES ('$address',1,0)");
mysql_query("UPDATE `users` SET sent =sent + 1 where address = '$addr';");
mysql_query("UPDATE `users` SET score =score - 1 where address = '$addr';");
echo '<script>self.parent.location="http://';echo $addr;echo'"</script>';
}else{
mysql_query("INSERT INTO users VALUES ('$address',1,0)");
echo '<script>self.parent.location="http://www.localhost"</script>';
};
};