title: select from 2 table and make ordering them
body: <p>first, sorry for my English ...<br>
  what i want is to select from two SQL tables and then make them in a specific order , like in forums ...<br>
  i have two table, topic and users, i want to select from both of them a putt author info next to his topic<br>
  here is the SQL of Topic and users</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `topics` (
    `id` int(11) NOT NULL,
    `id2` int(11) NOT NULL,
    `title` varchar(256) NOT NULL,
    `message` longtext NOT NULL,
    `author_id` int(11) NOT NULL,
    `timestamp` int(11) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  CREATE TABLE IF NOT EXISTS `users` (
    `id` bigint(20) NOT NULL,
    `username` varchar(255) NOT NULL,
    `password` varchar(255) NOT NULL,
    `email` varchar(255) NOT NULL,
    `avatar` varchar(255) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  </code></pre>
  
  <p>and the php code might look like this  </p>
  
  <hr>
  
  <pre><code>&lt;?php
  $sql = mysql_query(' MySQL query ... ');
  while($row = mysql_fetch_array($sql)) {
      echo '&lt;p&gt;'.$row['username']'&lt;br&gt;';
      echo $row['message'].'&lt;br&gt;&lt;/p&gt;';
  }
  ?&gt;
  </code></pre>
  
  <p>is there any way to do it ??  </p>