[PHP-DB] short text strings with apostrophes and forms

2006-04-20 Thread Jeffrey
I have an application which calls up some data from a MySQL table and puts it into a web form for users to modify. One of the cells holds a text string which is put into a text input field. However, if that text string includes an apostrophe, all text after the apostrophe disappears. For

Re: [PHP-DB] short text strings with apostrophes and forms

2006-04-20 Thread Charlie van de Kerkhof
Hi Jeffrey, try this: print input type='text' name='some_variable' value='.htmlspecialchars($some_text).'\n; Regards, - Charlie On 20 Apr 2006, at 17:56, Jeffrey wrote: I have an application which calls up some data from a MySQL table and puts it into a web form for users to modify. One

RE: [PHP-DB] short text strings with apostrophes and forms

2006-04-20 Thread Richard Leclair
-DB] short text strings with apostrophes and forms I have an application which calls up some data from a MySQL table and puts it into a web form for users to modify. One of the cells holds a text string which is put into a text input field. However, if that text string includes an apostrophe

Re: [PHP-DB] short text strings with apostrophes and forms

2006-04-20 Thread Luis Morales
Jeffry, I suggest use htmlentities/html_entity_decode functions. For example to update the db with values use: $myCol = htmlentities($mycol_value); Ej: query $query = update my_table set myCol='{$myCol}' where id = 'id_val'; Now when your application restore the data from the db you can use:

Re: [PHP-DB] short text strings with apostrophes and forms

2006-04-20 Thread dpgirago
I have an application which calls up some data from a MySQL table and puts it into a web form for users to modify. One of the cells holds a text string which is put into a text input field. However, if that text string includes an apostrophe, all text after the apostrophe disappears. For

Re: [PHP-DB] short text strings with apostrophes and forms

2006-04-20 Thread Jeffrey
[EMAIL PROTECTED] wrote: I have an application which calls up some data from a MySQL table and puts it into a web form for users to modify. One of the cells holds a text string which is put into a text input field. However, if that text string includes an apostrophe, all text after the