Re: Multiple Inserts
| From: | Daniel Clark | Date: | Tue, 22 Jun 2004 17:41:27 +0000 |
| Subject: | Re: Multiple Inserts | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34862@lists.php.net to get a copy of this message | ||
Any errors? Is the all the other data inserting into the second table?
> Hello,
> I am using a form to Insert data into 2 tables in the same database.
>
> $TimesheetID needs to be in each table. However, it is not being inserted
> into the second table, "tblTimesheetDetails" . Any advise?
>
> $result_timesheet=mysql_query("INSERT INTO tblTimesheet (TimesheetID,
> WorkerID, ClientID, TimesheetDate, ProspectiveOrRetrospective) VALUES
>
> ('$TimeSheetID','$WorkerID','$ClientID','$TimesheetDate','$ProspectiveOrRetr
> ospective')")or die("Insert Error: ".mysql_error());
>
> $result_timesheetdetails=mysql_query("INSERT INTO tblTimesheetDetails
> (TimesheetID, ActivityTypeID, TimeSpentHours, TimeSpentMinutes) VALUES
>
> ('$TimeSheetID','$ActivityTypeID','$TimeSpentHours','$TimeSpentMinutes')")or
> die("Insert Error: ".mysql_error());
>
>
> Thanks,
> Declan.