Multiple Inserts
| From: | Achieve IT | Date: | Tue, 22 Jun 2004 16:40:26 +0000 |
| Subject: | Multiple Inserts | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-34859@lists.php.net to get a copy of this message | ||
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.