Mysql Error Message
| From: | Graham Pearson | Date: | Fri, 04 Aug 2000 23:36:49 +0000 |
| Subject: | Mysql Error Message | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-10215@lists.php.net to get a copy of this message | ||
Hello:
I am creating a series of webpages to enter data into a mysql database. I have copied code out of another series of webpages that I have done that work on the insert query. Below is the insert query and in the web browser I get a message that states:
Warning: MySQL: Unable to save result set in /d1s0/apache/htdocs/Alumni/alumniadd.php3 on line 216
Insert into caston (Last_Name, First_Name, Graduation_Year, City, State, ZipCode, Email_Address) Values ('Pearson', 'Graham', '1998', 'Granger', 'Indiana', '12345', 'gpearson@niesc.org')
Error with the SQL Insert Command
Here is line 216 of alumniadd.php3
$Insert_Query = "Insert into $ALUMNI_TABLE (Last_Name, First_Name, Graduation_Year, City, State, ZipCode, Email_Address) Values ('$Last_Name', '$First_Name', '$Graduation_Year', '$City', '$State', '$ZipCode', '$Email_Address')";
Anyone see a problem with this insert query? The form values are passed via hidden values
-----------------------------------------------------
Click here for Free Video!!
http://www.gohip.com/free_video/