On Sat, 2002-07-13 at 00:52, Jason Wong wrote: > 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 ?
That was it, Thanks, works fine now. > > $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; # ??? What does that do? And would I put it somewhere in my web page code? I've not seen this before. Thanks for the help. -- Chip > > -- > 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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php