Re: Update problems
| From: | Miles Thompson | Date: | Wed, 13 Dec 2000 12:42:39 +0000 |
| Subject: | Re: Update problems | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5206@lists.php.net to get a copy of this message | ||
Richard Allsebrook wrote:
> Is the grade you are updating a number or a string, if it's a number your
> code needs to be:
>
> $Final="update student set finalGrade=$Final_grade where userId='Uname';";
Leave off the semi-colon.
MT
>
>
> _____
>
> ~ Richard Allsebrook ~
> Applications Developer and Webmaster
> Easysoft Limited, No3 The Embankment, Leeds, LS1 4BJ
> http://www.easysoft.com
> <http://www.easysoft.com> -
> http://www.cinema.com
> <http://www.cinema.com>
> "A computer lets you make more mistakes faster than any invention in human
> history - with the possible exceptions of handguns and tequila."
>
> _____
>
> -----Original Message-----
> From: Brinzoi Constantin Aurelian [mailto:aurel@irecson.ro]
> Sent: Wednesday, December 13, 2000 8:35 AM
> To: Jon McFarling
> Cc: php-db@lists.php.net
> Subject: Re: [PHP-DB] Update problems
>
> Hi Jon !
>
> Constantin Brinzoi
> Dept. Sondaje
> IRECSON
>
> On Tue, 12 Dec 2000, Jon McFarling wrote:
>
> > I am having problems updateing in MySQL
> > I run this script
> > $Final_grade=87.8;
> >
> > $Final="update student set finalGrade='$Final_grade' where
> > userId='Uname';";
>
> Maybe you want to replace 'Uname' with '$Uname' ?
>
> > $succes=mysql_query($Final,$link);
> > echo mysql_error()."<br>";
> > echo "<p align=\"center\"><font size=\"4\">Final
> > Grade:
> > $Final_grade</font></p>";
> >
> > and nothing happens in the data base. I have changed the user's permissons
> > to allow him to update but when I check the database nothing has changed
> > Jon
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> > For additional commands, e-mail: php-db-help@lists.php.net
> > To contact the list administrators, e-mail: php-list-admin@lists.php.net
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net