Joining tables

[Anon]

I am trying to join a table and fatch an array. But it does not like the ID value. Any sugestions.??

$db = mysql_connect("hostname","username","pass");
mysql_select_db("databasedb",$db);

$result = mysql_query("SELECT * FROM companys, clients WHERE companys.ID = clients.ID and ID = '$id'",$db);

while ($myrow = mysql_fetch_array($result))

bla bla bla

[Anon]

Here it is again it didnt come out well in the last posting

("SELECT * FROM companys, clients WHERE companys.ID = clients.ID and ID = '$id'",$db);

[Anon]

Perhaps this is what you are trying to do?

$query = "SELECT * FROM companys, clients WHERE companys.ID = $id AND clients.ID = $id";

$result = mysql_query($query);

I may be wrong on this, but from what I gathered from your message (hint more info helps when asking for help) this is what you are trying to do.

[Anon]

i was wondering about that to, thanks