Re: Add data to three tables at once from one form
| From: | Steve Werby | Date: | Thu, 19 Apr 2001 00:33:49 +0000 |
| Subject: | Re: Add data to three tables at once from one form | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-49290@lists.php.net to get a copy of this message | ||
"Fates" <fates@home.com> wrote:
> I know how to add data to one table but how do I add data to three
> tables from one form?
>
> I want to do this with just one form and on one web page so it doesn't
> post to another page.
>
> How do I set up the insert statement?
>
> $query = "INSERT INTO $table VALUES ('$menu_id', '$server',
> '$menunumber', '$menuname')";
>
> $result = mysql_db_query($dbname, $query);
Add two more sets of statements like those you have for the first query.
That's it. There's nothing special to do.
--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/