SQL query terminating early

[Anon]

What I'm trying to do is store code inside of a MySQL database.

The problem...
When I enter in code with " marks, it terminates the query early.

What I need...
Some type of solution to this problem.

Thanks in advance if u know of a solution.

[Anon]

It appears you don't have 'magic_quotes' set on.
If you can't set this (or have your host master
do so for you if it's a shared site) then you can
always use addslashes()...

[Anon]

Yes, I'm on a shared site. I tried using addslashes() in my SQL query but it still didn't work. Here is what the query looks like...

$sql = "INSERT INTO $table_name (id, fname, lname, email, title, code_desc, code_notes, code, date_added)
values
(\"\",\"$fname\",\"$lname\",\"$email\",\"$title\",\"$code_desc\",\"$code_notes\",\"addslashes($code)\",\"$date_added\")
";

[Anon]

And what does the query really ook like?

add this line after the one you posted:

print $sql;

then see what it is you are trying to execute.

[Anon]

use the addslashes out side of your string...it's a function.
use single quotes in your $sql definetion.
if id is an auto_increment column, just leave it out.
and, last but not least, read the manual!

$code = addslashes($code);
$sql = "INSERT INTO $table_name (fname, lname, email, title, code_desc, code_notes, code, date_added) values ('$fname','$lname','$email','$title','$code_desc','$code_notes','$code','$date_added')";

---John Holmes...