On Saturday 13 July 2002 14:49, Chip Wiegand wrote: > I just set up a pc with mysql-3.23.51/php-4.2.1/apache-1.3.26. I have > created a database and tables and a web interface to insert data into > it. I can insert data from the command line just fine. From the web > interface there is nothing inserted and no error messages. I have tried > connection string with root and with user names, both of which can > insert data from a remote client as well as on the sql server itself. > When I enter data and press submit the page redraws, and I don't get the > message the data was entered, and checking the database, I see nothing > indeed was entered. I've used post and get, makes no differance. In the > database I have set the fields as int, small int, varchar (shows char in > describe table_name), makes no differance. > I have made other web interfaces to mysql databases before, on slightly > older versions of mysql/php/apache and have never had this problem. > If anyone has a few minute to review my code below, hopefully someone > will find whatever it is I am missing. I have pasted in the html for the > web page, and below that a .csv copy/pasted of the database.
register_globals ? > $sql = "INSERT INTO legs > (squats,squats_reps,legpress,legpress_reps,legext,legext_reps,legcurls, > legcurls_reps,calfraise,calfraise_reps,hipabducter,hipabducter_reps, > hipadducter,hipadducter_reps,comments) VALUES('$squats','$squats_reps', > '$legpress','$legpress_reps','$legext','$legext_reps','$legcurls', > '$legcurls_reps','$calfraise','$calfraise_reps','$hipabducter', > '$hipabducter_reps','$hipadducter','$hipadducter_reps','$comments')"; echo $sql; # ??? -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* Hating the Yankees is as American as pizza pie, unwed mothers and cheating on your income tax. -- Mike Royko */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php