Truncated query in mysql_error() output

Anon

Hi all,

I am attempting to use the following query on a content publishing tool I am building:

$sql = "INSERT INTO $table_name (id, first_name, last_name, picurl, comment) VALUES (\"\", \"$firstname\", \"$lastname\", \"$distinct_image_name\", \"$comment\")";

the output that i get when i run that query is:

You have an error in your SQL syntax near 'distinct (id, first_name, last_name, picurl, comment) VALUES ("", ABC, , abc.gif' at line 1

Any idea on what is going on here? I have triple checked the form that input the information, it is as follows:

<FORM enctype="multipart/form-data" ACTION=do_update_distinct.php METHOD=post>
<input type="hidden" name="MAX_FILE_SIZE" value=1000000>Distinct or Extinct Publish tool<P>
<span CLASS=footer_link>First Name:</SPAN><INPUT TYPE=TEXT NAME=firstname SIZE=25 TABINDEX=1 CLASS=INPUT_TEXT MAXLENGTH=50><BR>
<span CLASS=footer_link>Last Name:</SPAN><INPUT TYPE=TEXT NAME=lastname SIZE=25 TABINDEX=2 CLASS=INPUT_TEXT MAXLENGTH=50><BR>
<span CLASS=footer_link>Upload Image / Logo:</SPAN><INPUT TYPE=FILE NAME=distinct_image><BR>
<span CLASS=footer_link>Distinct Caption:</SPAN><TEXTAREA NAME=comment ROWS=5 COLS=30></TEXTAREA><P>
<input TYPE=SUBMIT NAME=submit VALUE=submit>
</FORM>

any input you can give is very appreciated!

Anon

why are you escaping the quotes? ...

$sql = "INSERT INTO $table_name (id, first_name, last_name, picurl, comment) VALUES ('', '$firstname', '$lastname', '$distinct_image_name', '$comment')";

note if ID is an autoincrement field you dont want to mention it at all...

$sql = "INSERT INTO $table_name (first_name, last_name, picurl, comment) VALUES ('$firstname', '$lastname', '$distinct_image_name', '$comment')";

Anon

I mentoned the ID and escaped the quotes because the manual I have instructed it that way.

after removing the escapes, changing the quotes to ' and removing the referrence to id, the error i recieve is:

You have an error in your SQL syntax near 'distinct (first_name, last_name, picurl, comment) VALUES ('ABC', '', 'abc.gif', ' at line 1

fitzbean

Change your table name. DISTINCT is a MYSQL function. 🙂

fitzbean

I addition, there was nothing wrong with escaping thwe quotes, it just doesn't look pretty at all. 🙂 99% of the time you can use the combination of " and ' to get the job done instead.

Anon

OMG!!!!!!!

That was it. I would feel like a complete retard if I wasnt a total MySQL newbie... I feel kinda dumb anyway.

Ha!

Thanks, all!

fitzbean

Nah, it's anot a widely used function -- I didn't even know it was a function, but when I saw the table name DISTINCT, and saw that there was no other apparent errors, I thought to check to see if it was and low and behold 🙂

Anyway your welcome, anytime.