How to update two table under 1 script

[edikasim81]

I had two tables in my database. The table is like below:

Table 1 : MainData

• No_Permohonan (Primary_Key)
• No_Fail
• Tarikh_Permohonan
• Nama_Pemohon

Table 2 : StatusPermohonan

• No_Permohonan (Foriegn Key)
• Mukim
• Tempat

I create a script like below to update the data in table MainData :

<?php

include '../dbase.php';

$query = "UPDATE MainData SET
No_fail = '$No_fail',
Tarikh_Permohonan = '$Tarikh_Permohonan',
Nama_Pemohon = '$Nama_Pemohon'
WHERE No_Permohonan = '$No_Permohonan'";

$result = mysql_db_query($dbname,$query);

:
:
?>

Plz show to me how the script can update automatically field No_Permohonan in table StatusPermohonan under one script..

[bretticus]

Ummm...you can just do another update in succession. In other words send an update command immediately after the one you just sent using the same code again. You can use: WHERE No_Permohonan = '$No_Permohonan' again in the next command text as I notice No_Permohonan is a foreign key.

If your question is really, "How can I update 2 tables with one query?"...

That is relatively simply too. Use something similiar to:

UPDATE table1,table2 SET table1.field = 'some value', table2.field = 'some value'

This muli-table update only works with MySQL 4.0.4 and above