[Resolved] user memberships

[corruption]

again with inserting things into the database

error message says

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 'in, password, phone, address, city, state, zip, birthdate, big,

code for inserting the values is here

mysql_query("INSERT INTO brothers(name, major, major2, minor, minor2, minor3, email, in, password, phone, address, city, state, zip, birthdate, big, little, little2, little3, little4, image)		
	VALUES('$name', '$major', '$major2', '$minor', '$minor2', '$minor3', '$email', '$in', '$password', '$phone', $address', '$city', '$state', '$zip', $bithdate', '$big', '$little', '$little2', '$little3', '$little4', '$image');") or die (mysql_error());

?>

[bubblenut]

In's a reserved word, you can't (or at least shouldn't, I think can't) use it as a column name. If your table has this as a column name and you do not wish to change it (which is what you should do) you can place backticks around it in.
HTH
Bubble

[corruption]

fixed that and a few other fields that i think may have been reserved words

here's the error

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 '', 'Hatim Kolwhapaluar', 'Darryl Walker', '', '', '')' at line

here's the code

//insert the data into the database brothers
mysql_query("INSERT INTO brothers(name, major, major2, minor, minor2, minor3, email, number, password, phone, address, city, state, zip, birthdate, bigbrother, littlebro, little2, little3, little4)		
	VALUES('$name', '$major', '$major2', '$minor', '$minor2', '$minor3', '$email', '$number', '$password', '$phone', '$address', '$city', '$state', '$zip', $birthdate', '$bigbrother', '$littlebro', '$little2', '$little3', '$little4');") or die (mysql_error());

[bubblenut]

Place the query string into a variable first and then echo the variable. I think the problem may be an apostrophe or a backslash in one of the variables. If this turns out to be the case use [man]addslashes()[/man]
HTH
Bubble

[corruption]

so like this

$sql = "INSERT INTO brothers(name, major, major2, minor, minor2, minor3, email, number, password, phone, address, city, state, zip, birthdate, bigbrother, littlebro, little2, little3, little4)		
	VALUES('$name', '$major', '$major2', '$minor', '$minor2', '$minor3', '$email', '$number', '$password', '$phone', '$address', '$city', '$state', '$zip', $birthdate', '$bigbrother', '$littlebro', '$little2', '$little3', '$little4');") or die (mysql_error());

echo $sql;	

or

$sql = mysql_query("INSERT INTO brothers(name, major, major2, minor, minor2, minor3, email, number, password, phone, address, city, state, zip, birthdate, bigbrother, littlebro, little2, little3, little4)		
	VALUES('$name', '$major', '$major2', '$minor', '$minor2', '$minor3', '$email', '$number', '$password', '$phone', '$address', '$city', '$state', '$zip', $birthdate', '$bigbrother', '$littlebro', '$little2', '$little3', '$little4');") or die (mysql_error());

echo $sql;

[bubblenut]

the first one but remove the ) or die(mysql_error()) from the end.

[corruption]

this is what i have no and i get nothing....

if (!get_magic_quotes_gpc()) {
  $name = mysql_escape_string($name);
  $major = mysql_escape_string($major);
  $major2 = mysql_escape_string($major2);
  $minor = mysql_escape_string($minor); 
  $minor2 = mysql_escape_string($minor2);
  $minor3 = mysql_escape_string($minor3);
  $email = mysql_escape_string($email);
  $number = mysql_escape_string($number); 
  $password = mysql_escape_string($password);
  $phone = mysql_escape_string($phone);
  $address = mysql_escape_string($address);
  $city = mysql_escape_string($city);
  $state = mysql_escape_string($state);
  $zip = mysql_escape_string($zip);
  $bithdate = mysql_escape_string(birthdate);
  $bigbrother = mysql_escape_string($bigbrother); 
  $littlebro = mysql_escape_string($littlebro);
  $little2 = mysql_escape_string($little2);
  $little3 = mysql_escape_string($little3);
  $little4 = mysql_escape_string($little4);  

}
//add slashes
$name = addslashes($name);
$major = addslashes($major);
$major2 = addslashes($major2);
$minor = addslashes($minor);
$minor2 = addslashes($minor2);
$minor3 = addslashes($minor3);
$email = addslashes($email);
$number = addslashes($number);
$password = addslashes($password);
$phone = addslashes($phone);
$address = addslashes($address);
$city = addslashes($city);
$state = addslashes($state);
$zip = addslashes($zip);
$birthdate = addslashes($birthdate);
$bigbrother = addslashes($bigbrother);
$littlebro = addslashes($littlebro);
$little2 = addslashes($little2);
$little3 = addslashes($little3);
$little4 = addslashes($little4);
//insert the data into the database brothers
$sql = "INSERT INTO brothers(name, major, major2, minor, minor2, minor3, email, number, password, phone, address, city, state, zip, birthdate, bigbrother, littlebro, little2, little3, little4)		
	VALUES('$name', '$major', '$major2', '$minor', '$minor2', '$minor3', '$email', '$number', '$password', '$phone', '$address', '$city', '$state', '$zip', $birthdate', '$bigbrother', '$littlebro', '$little2', '$little3', '$little4');"

echo $sql;
mysql_query($sql);

?>

EDIT: in reading addslashes() in php manual, i realized that i shouldn't use it with the get_magic_quotes_gpc command.