Re: cannot write to mySQL database

"Nicole Amashta" <430ntr3k@bellsouth.net> wrote in message news:20020304162709.7403.qmail@pb1.pair.com... > Could you post the code you are trying to use to do this? It may just be a > coding issue and not MySQL at all. > Sure. The database is called movies1db, username is movies, password is database. This definitely could be an issue with how i set up the user or something. Here's the code for one form I'm trying: ------- <html> <body> <?php if ($submit) { // process form $db = mysql_connect("localhost", "movies","database"); mysql_select_db("movies1db",$db); $sql = "INSERT INTO tbl1 (name,location,length,size,description) VALUES ('$name','$location','$length','$size','description')"; $result = mysql_query($sql); echo "Thank you! Information entered.\n"; } else{ // display form ?> <form method="post" action="<?php echo $PHP_SELF ?>"> Name:<input type="Text" name="name"><br> Location:<input type="Text" name="location"><br> Length:<input type="Text" name="length"><br> Size:<input type="Text" name="size"><br> Description:<input type="Text" name="description"><br> <input type="Submit" name="submit" value="Enter information"> </form> <?php } // end if ?> </body> </html> ------ Here's more info. I checked my apache error log and found that when I open that page, I get the following errors: [Mon Mar 04 12:14:27 2002] [error] PHP Warning: Undefined variable: submit in c:\homepage\phptest\dataform2.php on line 11 [Mon Mar 04 12:14:27 2002] [error] PHP Warning: Undefined variable: PHP_SELF in c:\homepage\phptest\dataform2.php on line 37 I get the same errors when I hit the submit button. Hope this helps! Dave