Slash problem

[sethcox]

I am getting this error:

Unable to add entry: Unknown ODBC error
SQL: INSERT INTO webcal_entry ( cal_id, cal_create_by, cal_date, cal_time, cal_mod_date, cal_mod_time, cal_duration, cal_priority, cal_access, cal_type, cal_name, cal_description ) VALUES ( 23, 'scox', 20021113, -1, 20021113, 92829, 0, 2, 'P', 'E', 'tes\'s', 'tes\'s' )

It's because of the tes's

I've tried using htmlspecialchars and stripslashes and addslashes but I can't get it to accept the '

Any help?

Thanks!!

[harlowhair]

$word = tes's;
$word2 = addslashes($word);
echo($word2)

outputs tes\'s

just addslashes should work fine

[sethcox]

With addslahes I get:

Error
Unable to add entry: Unknown ODBC error
SQL: INSERT INTO webcal_entry ( cal_id, cal_create_by, cal_date, cal_time, cal_mod_date, cal_mod_time, cal_duration, cal_priority, cal_access, cal_type, cal_name, cal_description ) VALUES ( 23, 'scox', 20021113, -1, 20021113, 102056, 0, 2, 'P', 'E', 'test\\'s', 'test\\'s' )

If I don't convert anything and just let it try to submit it exactly as it was typed, I get:

Error
Unable to add entry: Unknown ODBC error
SQL: INSERT INTO webcal_entry ( cal_id, cal_create_by, cal_date, cal_time, cal_mod_date, cal_mod_time, cal_duration, cal_priority, cal_access, cal_type, cal_name, cal_description ) VALUES ( 23, 'scox', 20021113, -1, 20021113, 102212, 0, 2, 'P', 'E', 'test\'s', 'test\'s' )

[Quevas]

Try replacing te's with te''s, with MySQL it works...

[sethcox]

Can you show me how to do this? I tried this but it didn't work:

$name = str_replace('\'', '''', $name);