php and myql database problem
<pre><code>&lt;?php 
  include('includes/config.php');
  $topi  =$_GET['id']; //id of url

   mysql_select_db("ban", $con);

   $query = "SELECT *
               FROM `basic`
              WHERE id = '$topi'
              LIMIT 0, 30"; 

  $result = mysql_query($query) or die(mysql_error());

  $row = mysql_fetch_array($result) or die(mysql_error());

    $aa = $row['item'];
    $cc = $row['moreinfo'];
    $dd = $row['contactinfo'];
    $ff = $row['id']; ?&gt;
</code></pre>

<p>In this script, I am retrieving information from the table "basic", but i want to retrieve data from another table named "users" . How can i retrieve data from two tables at once?</p>

<p>user table consists of following columns</p>

<ul>
<li>email</li>
<li>username </li>
<li>ID  </li>
</ul>
