Sql statement

[fyrafadhli]

hello...
I want to ask about how to use sql statement when I have 2 tables and I want to display information from both table by using their ID.
Here I have 2 tables.
Table 1 is journal:
This table have journal_ID and authorID

Table 2 is author:
This table have authorID and author_name

So, I want to display info from table journal and get the author name from table author.But I can't display the author name.
Here are my coding:

$result = mysql_query("SELECT * FROM journal HAVING description LIKE '%".$keyword."%' OR description LIKE '%".$keyword."%'");
       if (!$result || mysql_num_rows($result) < 1) {
        $href = "user_browse_1.php";
        print"<meta HTTP-EQUIV='REFRESH' CONTENT='1; URL=".$href."'><div class='sub_title'>item not found...</div><br><br><br>";
       }

and

$result2 = mysql_query("SELECT name FROM author WHERE authorID=$item_Author");
         while($row2 = mysql_fetch_array($result2))
         {
          $authorname=$row2["authorID"]; 
         }

Hope can hear from you soon.TQ

[vinyl-junkie]

You only need one query to get what you want, by using an inner join like so:

$result = mysql_query("SELECT * FROM journal 
HAVING description LIKE '%".$keyword."%' OR description LIKE '%".$keyword."%'
INNER JOIN journal on journal.AuthorID = author.AuthorID");