Re: cannot write to mySQL database

OK, go to your php.ini file and change your error_reporting level to this: error_reporting = E_ALL & ~E_NOTICE See if that at least yields different "error" or "warning" messages. Let me know what happens. Nicole www.aeontrek.com "Pilotdave" <pilotdaveg@yahoo.com> wrote in message news:20020304173427.66115.qmail@pb1.pair.com... > > "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 > >