i get this error when i execute the PHP here there is no problem entering data its only when the submit button is pressed that the error happens.Please help Im stuck and a newbie in php!

New member registration

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 ' 1, 0, 0, 0, '2007-01-19 22:12:42', 0, '2007-01-19 22:12:42', 'n

<?php

session_start();

session_register("sess_data");

session_register("ref");

session_register("sess_name");

session_register("sess_passwd");

include("vars.php");

include("headfoot.php");

mysql_connect($db_host, $db_user, $db_pwd);

mysql_select_db($db_name);

if ($_SERVER['REMOTE_ADDR']=='127.0.0.1') {$_SERVER['REMOTE_ADDR']=$_SERVER['HTTP_...

if ($_GET['ref'] && is_numeric($_GET['ref'])) {

$rck = mysql_query("SELECT * FROM user WHERE id=$_GET[ref] && status='Active'");

if (mysql_num_rows($rck) != 0) {

$acctype = mysql_result($rck, 0, "acctype");

$creditme = mysql_result(mysql_query("SELECT rpgebonus FROM acctype WHERE id=$acctype"), 0);

$_SESSION['ref'] = $_GET['ref'];

$ipis = $_SERVER['REMOTE_ADDR'];