Having ID in to different tables?

[Anon]

I have companyid field in two tables! On in the client table and one in the company table. The idea is so I can join them later down the line for searchs. The problem is when the site gets a new client how do i get PHP to drop the same ID in both tables.

Thanks You
Michael

[Anon]

<?php
// Connect to database.
$companyid = 3;
// Since this will be the same, it will be
// used to seed the two commands to mysql.

// Command One to Company Table.
$query = "delete from company where id = '$companyid'";
$result = mysql_query($query) or die("Error 1 when removing information.");

// Command Two to Client Table.
$query = "delete from client where id = '$companyid'";
$result = mysql_query($query) or die("Error 2 when removing information.");

// Close connection to database.
?>

This is only if you are wanting to delete the whole row. If not then just use and update command.