URGENT - NEED TO FINISH @ MIDNIGHT! Please HELP!

[phpn00bf4life]

Why won't this update anything? Please HELP! http://digishop4u.com/in.php?id=12

<?php
/*
**Page Created On: Thursday May 18, 2005 @ 6:41PM
**Page Created Via:  PHP, Crimson Editor
**Page Title:  Refer In
**Page Quick Bio:  Quickly add up refer points, unique hits etc
*/
include("config.inc.php");
$get_user = "SELECT * FROM hard_users WHERE uid='$id'";
$fin_get_user = mysql_query($get_user);
while($add = mysql_fetch_array($fin_get_user)){

$the_added = $add['refers'] + 1;
$ip = $REMOTE_ADDR;
$ip_check = "SELECT * FROM hard_refer WHERE uid='$id'";
$ip_check_finish = mysql_query($ip_check);
while($ipcheck = mysql_fetch_array($ip_check_finish)){
	if($ip = $ipcheck['ip']){
		//Not a new one...
	} else {
		$add2_pre = $add['refers_unique'];
		$the_added2 = $add2_pre +1;
		$update2 = mysql_query("UPDATE hard_users SET unique_refers='$the_added2' WHERE uid='$id'");
		$fin_update2 = mysql_query($update2);
		$update3 = mysql_query("INSERT INTO `hard_refer` ( `uid` , `ip` , `refers` ) 
VALUES (
'".$id."', '".$ip."', '0'
)");
		}
	}
	$update = mysql_query("UPDATE `hard_users` SET `refers` = '".$the_added."' WHERE `uid` =12 LIMIT 1 );
}


echo'<meta http-equiv="Refresh"
content="5;url=digishop4u.com">';
?>

[bradgrafelman]

First of all, this line:

    $update = mysql_query("UPDATE `hard_users` SET `refers` = '".$the_added."' WHERE `uid` =12 LIMIT 1 ); 

is missing an ending double quote, should be:

    $update = mysql_query("UPDATE `hard_users` SET `refers` = '".$the_added."' WHERE `uid` =12 LIMIT 1"); 

Second of all, the error on the link you provided says that you specified a column that doesnt exist in the MySQL table (id_link), though I don't see that in your code. Try fixing the above error and let us know.