----- Original Message -----
From: "Adrian D'Costa" <[EMAIL PROTECTED]>
To: "Mysql Mailing List" <[EMAIL PROTECTED]>
Sent: Friday, June 08, 2001 13:59
Subject: php/mysql question
> 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;
What you wrote here and what you wrote below are not the same
update vusers set name="Adrian D'Costa" where id=3;
&
update vusers set name='Adrian D\'Costa' where id=3;
will both work. Look up the section on escaping special characters in the
mysql manual.
> '>
>
> 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
---------------------------------------------------------------------
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