Another thing I suggest is, instead of relying on the value from $submit
(your submit button), create a hidden field and call it "action" or whatever
you want that makes sense to you. This hidden field will store the value of
the action you will take when the form is submitted. For example, you can
call it "action" and give it the value "submit."
Ex:
<input type="hidden" name="action" value="submit">
Then, in your php, you can do this:
If ( $action == "submit" )
## do your insert query here
}
else {
## display the form
}
Good luck,
Nicole
www.aeontrek.com
"Pilotdave" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED].;
>
> "Nicole Amashta" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED].;
> > 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
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
