Inserting data into two tables at once

[endlyss]

Hello

I want to insert data into two tables at once...

Table "washington" fields =...
zone, zone_desc, date_last_visited, current_status, truck_no, driver

Table "sectors" fields =...
zone, sector

I know it's a mess but my brain collapsed, what I'm doing looks something like this...

$sql = "select w.zone, zone_desc, date_last_visited, current_status, truck_no, driver s.sector from washington w, sectors s insert values ('$zone', '$zone_desc', '', '', '', '', '$sector');

Can somone shed some light on the syntax I need to use?

Thank you very much!

Richard

[Anon]

Sorry, you can't (least with mysql). Use two queries.

[Anon]

It cannot be done by one query, I've done this by putting two queries:

$one ="INSERT INTO temporaryData (field1, field2, field3) VALUES ('one','two','three')";

$two ="INSERT INTO temporaryCalc (field1, field2, field3) VALUES ('one','two','three')";

$result1 = mysql_query($one, $db) or die("query error");
$result2 = mysql_query($two, $db) or die("query error");