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:
$mycol_value = html_entity_decode ($myCol);
$mycol_value: is the value from html form
$myCol: is the name of your colum's table to update in your query.
Good luck,
Regards,
Luis Morales
On Thu, 2006-04-20 at 17:56 +0200, 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 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 example, if the test string from a database cell reads...
>
> Fix the managers' cars by Tuesday
>
> and that is saved in the variable $some_text, which is called up in a
> form...
>
> <input type='text' name='some_variable' value='$some_text'>
>
> The text field on the web page will only contain...
>
> Fix the managers
>
> How can I get the text field to show the entire string?
>
> Many thanks,
>
> Jeffrey
>
--
---------------------------------------------------------------------------------
Luis Morales
Consultor de Tecnologia
Cel: +(58)416-4242091
---------------------------------------------------------------------------------
"Empieza por hacer lo necesario, luego lo que es posible... y de pronto
estarás haciendo lo imposible"
---------------------------------------------------------------------------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
