On Fri, 8 Jun 2001, Rolf Hopkins wrote:
>
> ----- 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
True.
>
> update vusers set name="Adrian D'Costa" where id=3;
This is at the mysql prompt
>
> &
>
> update vusers set name='Adrian D\'Costa' where id=3;
and this is thru the script. Both work at the mysql prompt. But this
will not work thru the script. Don't know why.
>
> will both work. Look up the section on escaping special characters in the
> mysql manual.
Mysql Manual, hmmm.... I remember seeing that when I was with rh6.0 when I
installed rh7.0 no manual. Give me a link to download it.
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