Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2000121

RE: [PHP-DB] Update problems From: Richard Allsebrook (richard.allsebrook <email protected>)
Date: 12/13/00

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';";

  _____

~ 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>