Bug #18070 Updated: INSERT failure

ID: 18070 Updated by: derick@php.net Reported By: Akujin11@yahoo.com Status: Feedback Bug Type: MySQL related Operating System: Windows XP PHP Version: 4.2.0 New Comment: Try the latest version (4.2.1) first Previous Comments: ------------------------------------------------------------------------ [2002-06-30 05:03:22] Akujin11@yahoo.com i have tried several methods of inserting rows and everything has failed. the only way i can insert data is to open MySQL and insert it manually thought the DOS prompt. i have noticed that a LOT of people are having the same problem. my setup is the same as it was before i upgraded, and the code is exactly the same (i'm using the same, unmodified, file) and yet after the upgrade my insert functions cease to work. a SELECT query does, however, work. ------------------------------------------------------------------------ [2002-06-30 04:54:58] sander@php.net You're _very_ likely doing something wrong. Does mysql_error() say something? Can you use insert rows with for example phpMyAdmin? ------------------------------------------------------------------------ [2002-06-30 04:46:19] Akujin11@yahoo.com I'll start with the code that is the source of the problem: function submit_values($char_name, $str, $spe, $skill, $def, $pow) { $submittal = "INSERT INTO stats (name, strength, speed, skill, defense, power) VALUES ('$char_name', $str, $spe, $skill, $def, $pow);"; $submittal_q = mysql_query($submittal) or die(mysql_error()); echo "Added $char_name, $str, $spe, $skill, $def, $pow"; } now that the code is stated, i'll give the problem, and it is a simple one: this code does nothing. it is the same exact code i was using successfully before upgrading to 4.2.0, however now it does absolutly nothing. the code processes, acts as if nothing is wrong, however when executed absolutly no information is being added to my database. i request that you NOT simply say "consult the users manual" like you have to so many other people, because it solves nothing. i would like a REAL solution to this problem. -The Akujin. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=18070&edit=1