----- Original Message -----
From: "Adrian D'Costa" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>
Cc: "Mysql Mailing List" <[EMAIL PROTECTED]>
Sent: Friday, June 08, 2001 17:47
Subject: Re: php/mysql question
> 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.
Both should work through the script. What's the exact script and what's the
error?
>
> >
> > 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.
>
www.mysql.com
Don't tell me! You used RH's mysql RPM to install?!?! Ouuccchhhh!!! The
bane of many people's problems. If you ever find problems with mysql, get
the RPMs from Mysql's website instead.
---------------------------------------------------------------------
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
