Query within two separate tables

[miha]

Query within to separate tables, Need help
I have one table1 with four fields (field1, field2, field3, field4) and table2
with two fields (field1, field2).

As I would like to retrive information from table1 it will work:

$username=$_POST['fname'];

$query1 = "SELECT * FROM users
WHERE ime='$username'";
$result1 = mysql_query($query1) or die ("SQL error: $query -- " . mysql_error());
while ($row = mysql_fetch_array($result1))
{

$IDuser = $row["ID"];
$email = $row["email"];

}

But how to retrieve information from table 2 if this is another table and
it should retrieve last record in this table2 where is $IDuser from table 1.

Please help...

[edwardsbc]

Well, either run another query based on the result of $query1 or look up SQL Joins... Your question isn't specific enough to know what your desired outcome really is?

[miha]

I would like to retrieve from field email in table 2 data in LISTBOX.

Can you suggest me how to do it with code for

I would like to do it with code
PHP Code:
<SELECT NAME="email">
<?php
$users = mysql_table("SELECT * FROM users ORDER BY fname", $db);
foreach(...)
{
}

            ?>