RE: [PHP-DB] Update problems

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