MySQL not updating...

From: Date: Tue, 06 Jun 2000 19:17:06 +0000
Subject: MySQL not updating...
Groups: php.db 
Request: Send a blank email to php-db+get-226@lists.php.net to get a copy of this message
Hey there, Has anyone experienced problems using PHP4 to update MySQL databases? I know it sounds a little weird, but it seems that whenever I have created a new table that I want to work with and create a new php page to deal with it, the sql statements I use to update or insert into the table never actually update the table. Yet no error is returned. I'm on linux, using mysql and apache 1.3.12. My db connect statements all work for sure. And I've verified that the user I specify in my connect statements have access to the tables. The sql code is as follows: /////// if ($submit) { // This will process the form $sql = "INSERT INTO hist_info (fname,lname,dept,title,prior_agencies,nature_of_business,"; $sql .= "categories,previous_clients,areas_of_interest) VALUES ('$fname','$lname',"; $sql .= "'$dept','$title','$nature_of_business','$categories','$previous_clients',"; $sql .= "'$areas_of_interest')"; $iresult = mysql_query($sql); echo "Thank you! Information entered.\n"; } else { // It just displays the form again. } ?> ////// Maybe I'm not committing changes or something? Thanks! Marky

« previous php.db (#226) next »