6 messages in com.mysql.lists.win32Off topic (or is it?)
FromSent OnAttachments
Akhen16 Feb 2001 11:33 
James Treworgy16 Feb 2001 13:11 
Tim Endres16 Feb 2001 13:22 
Stephen Woodbridge16 Feb 2001 13:43 
Ray Cote16 Feb 2001 14:29 
Cynic16 Feb 2001 19:16 
Subject:Off topic (or is it?)
From:Akhen (ta@direct.a2000.nl)
Date:02/16/2001 11:33:59 AM
List:com.mysql.lists.win32

Hey all, this might be a little off topic, but it has to do with MySQL

Here is my problem: ==== if (isset($c)) {

$addcard = "INSERT INTO $user_table VALUES ('$firstname', '$lastname', '$nickname', '$street', '$zip', '$city', '$country', '$telephone1', '$telephone2', '$fax', '$email1', '$email2', '$birthdate', '$note');";

mysql_query($addcard,$conn) or die(mysql_error()); // echo "User $firstname $lastname added succesfully!"; }

==== What in this little code snippet is wrong? because I get an error message:

=== You have an error in your SQL syntax near 'VALUES ('foo', 'foo', 'foo', 'foo', 'foo', 'foo', 'the Netherlands', 'foo', 'foo' at line 1 ===

what error am I making? any advise?

thanks!

Yours truly

-Thijs Boonstra