' problem in mysqlquery & php

[Anon]

Hello everyone.
I have the following problem:

using php if in create a query like:

$query = $textfile; // ommitting insert statement etc..
// $textfile is content of a text file that i // read from a file.

then execute.. mysql_query($query);

the record is inserted into database ONLY
if $textfile does not contain a ' character, if it does contain a ' character i get an error:
1064
You have an error in your SQL syntax near 's

any suggestions? I do use addslashes($textfile) function.

[[deleted]]

Sounds like soemthing is wrong in the addslashes() function.
Are you sure you insert the 'addslashed' var and not the original?

[Anon]

Ohhh....my bad!

I was using the function as follow:
addslashes($query);

i should have used: $new_query=addslashes($query);

thanks man..

[[deleted]]

:-)