Hi,
I am not sure whether this relates to this list or the (not working) php
list.
For simplicity: I have a form that displays data from a table. I will
take just one field that displays a name
<input type="text" name="name" value="<? echo $row[name];?>">
This allow a user to update the changes when the submit button is pressed.
On the next php file I do the following:
$tname =urldecode($name);
$tname1 = stripslashes($tname1);
$updtStmt = "update vusers set orgname='$tname1' where id=$tid";
This works fine, but suppose in by table I have a name "Adrian D'Costa"
This starts all the problems. I copy the sql statement from the php file
and try:
update vusers set name='Adrian D'Costa' where id=3;
'>
I get the '> prompt that is waiting for me the close the '. If I try the
same statement in mysql command line:
update vusers set name="Adrian D'Costa" where id=3; Query OK, 0 rows
affected (0.01 sec)
Rows matched: 1 Changed: 0 Warnings: 0
It works. How do I do the same in php?
TIA
Adrian
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php