AW: certain content is causing an error with INSERT - please help

2005-02-13 Thread Frank Busch
OK, I use an older version of PHP where mysql_real_esacpe_strings isn't avail. But nevertheless I would always prefer double-quoting with $descrip_field=str_replace("'","''",$$descrip_field); This is because I got lot's of Problems with different languages on different databases when you try to m

Re: certain content is causing an error with INSERT - please help

2005-02-13 Thread Frank Busch
Hi leegold, I don't know what mysql_real_escape_string would do, because it isn't a standard-php-function. So I don't regard it and talk about the basics. In fact you have a string delimiter in "Librarian's Edition" so you have to escape it to make MySQL know where the string really ends. The

Re: certain content is causing an error with INSERT - please help

2005-02-12 Thread Michael Stassen
leegold wrote: I'm ripping hair out, here's the problem...I'm trying to insert content cited below into a field and it's causing this error, ie. there's content i just cannot insert into the DB an it's causing the following error message: "You have an error in your SQL syntax; check the manual that

certain content is causing an error with INSERT - please help

2005-02-12 Thread leegold
I'm ripping hair out, here's the problem...I'm trying to insert content cited below into a field and it's causing this error, ie. there's content i just cannot insert into the DB an it's causing the following error message: "You have an error in your SQL syntax; check the manual that corresponds t