Re: Update problems
| From: | Matthew Ballard | Date: | Tue, 12 Dec 2000 21:42:21 +0000 |
| Subject: | Re: Update problems | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5195@lists.php.net to get a copy of this message | ||
It is probably the userId part of the where clause. Currently, that would try to update a record called Uname, but I would assume you would be updating different records depending on who you are working on, because currently it is looking for a userId of Uname. My guess is that you want $Uname in there.
Matthew
At 01:31 PM 12/12/2000 -0800, you 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';"; $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