echo mysql table inside a new html or php page in php.

[spky]

I need to echo this table inside a web page and need to take a print-out.Records must select according to req_num which will be entered by user.(I defined it as $req) this code gave me this error
"Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in E:\wamp\www\STMS_2.4\printprew.php on line 23"
plz help

 
<?php
 
  require 'connection.php';
 
              //inner join...begins 28.02.2013-thilini
 
    if(isset($_POST['p'])){
 
        $req=$_POST['txtreq'];
 
        //$get=("select req_num from $tbltempisit Where req_num='$req'");
 
    $result = ("SELECT  $tbltempisit.item_name,$tbltempds.emp_name FROM $tbltempisit  INNER JOIN $tbltempds ON $tbltempisit.req_num = $tbltempds.req_num WHERE req_num ='$req' ");
 
     $query_r=mysql_query($result);
 
 
  echo "<table  border='1' id='data'>
  <tr>
  <th>Item</th>
  <th>name</th>
  </tr>";
  while ($row = mysql_fetch_array($query_r)) {
  echo "<tr>";
  echo "<td>" . $row['item_name'] . "</td>";
  echo "<td>" . $row['emp_name'] . "</td>";
  echo "</tr>";
  }
  echo "</table>";
 
 
 
    }
 
 
 
//inner join....ends
 
?>
 
 

[Rabbit]

mysql_query returns a resource on a select query only if it succeeds. Otherwise, it returns a boolean false. If you're getting a boolean, that means your query failed. Check the query string that it's running after the variables are translated to see if the query string is correct.