 |
 |
Find a programming school near you
php-db | 2000121
Date: 12/13/00
- Next message: omar cromwell mercado: "[PHP-DB] restricting oracle connections to specific ip"
- Previous message: Peter Johansson (BCS): "[PHP-DB] Problems connecting to Oracle 8.1.5 on remote machine"
- In reply to: Richard Allsebrook: "RE: [PHP-DB] Update problems"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 <email protected>]
> Sent: Wednesday, December 13, 2000 8:35 AM
> To: Jon McFarling
> Cc: php-db <email protected>
> 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 <email protected>
> > For additional commands, e-mail: php-db-help <email protected>
> > To contact the list administrators, e-mail: php-list-admin <email protected>
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe <email protected> For additional commands, e-mail: php-db-help <email protected> To contact the list administrators, e-mail: php-list-admin <email protected>
- Next message: omar cromwell mercado: "[PHP-DB] restricting oracle connections to specific ip"
- Previous message: Peter Johansson (BCS): "[PHP-DB] Problems connecting to Oracle 8.1.5 on remote machine"
- In reply to: Richard Allsebrook: "RE: [PHP-DB] Update problems"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
