Re: [PHP-DB] Multiple Inserts

Thanks for the suggestions. I have $TimeSheetID=$_POST['TimeSheetID']; at the start of the script. However, what I neglected to mention is that TimeSheetID is auto_increment, in first table, tblTimesheet. I will try the other suggestions, and respond with my results. Thanks, Declan.

[PHP-DB] Re: Multiple Inserts

Solved... I needed to find a way to get the latest auto_increment value. I did this using, $new_id = mysql_insert_id(); Thanks, Declan. Thanks for the suggestions. I have $TimeSheetID=$_POST['TimeSheetID']; at the start of the script. However, what I neglected

[PHP-DB] Multiple Inserts

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,

[PHP-DB] Printing anchor link in results

Hello, I am new to PHP and am wondering how to print a variable an external link. In the example below, the 'web_pro' variable has the format, www.mycompany.com . How can I make this a clickable link? echo \ntr\n\ttd bgcolor=\silver\ . bWeb: /b . $arr['web_pro'] .

[PHP-DB] Passing variable with previous next

Hello, I am working on a page that first collects a variable using POST, and which then uses same in the page which processed this variable. Everything works fine if I run the page with the variable already set (i.e. do not send it via POST from the page which calls the script. I have included

Re: [PHP-DB] Passing variable with previous next

Oops, I have actually defined $address_region = $HTTP_POST_VARS['address_region']; , I forgot to include in the snip in the first posting. Thanks, Declan. - Original Message - From: mike karthauser [EMAIL PROTECTED] To: Achieve IT [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday