RE: [PHP] submitting free-form text to a database

2001-07-16 Thread garman
= Original Message From Duncan Hill [EMAIL PROTECTED] = On Mon, 16 Jul 2001, garman wrote: box where the user enters a description of the item he is selling. If the user's input contains an apostrophe (aka a single quote ') or even a double quote, the code gets confused. addslashes()

RE: [PHP] submitting free-form text to a database

2001-07-16 Thread Rasmus Lerdorf
= Original Message From Duncan Hill [EMAIL PROTECTED] = On Mon, 16 Jul 2001, garman wrote: box where the user enters a description of the item he is selling. If the user's input contains an apostrophe (aka a single quote ') or even a double quote, the code gets confused.

Re: [PHP] submitting free-form text to a database

2001-07-16 Thread Francis Fillion
If I remember the best things with M$ oriented database, is to to double it so ' should be '' and it should be ok. Anyway, that's what I do when I have to do stuff with those software. garman wrote: = Original Message From Duncan Hill [EMAIL PROTECTED] = On Mon, 16 Jul 2001, garman

RE: [PHP] submitting free-form text to a database

2001-07-16 Thread scott [gts]
for the quotes thing. you must have single quotes around the values that will go to the database, and you must escape single quotes inside the value with either '' or \' (at least in MySQL, both work) and as for the database... IMO, you should download MySQL now and save yourself a ton of