mysql Syntax error

[einSTein]

$result2 = mysql_query("SELECT * FROM postjobs WHERE title='$id'"); 
echo "<center>";
echo "<table border='0'> 
<td>
<th>No.&nbsp;&nbsp;&nbsp;  </th> 
<th>Job Titles&nbsp;&nbsp;&nbsp;  </th> 
</tr>"; 
while($row2 = mysql_fetch_array($result2)) ------> error line
    { 
    echo '<tr>'; 
    echo '<td>' . $row['user'] . '</td>'; 
    echo '<td>' . $row['title'] . '</td>'; 
    echo '</tr>'; 
    } 
echo "</table>"; 
echo "</center>";

this is my error note: the while line is line 14

Warning: Supplied argument is not a valid MySQL result resource in c:\apache\htdocs\gp1\ps.php on line 14

[byron3@earthlink]

Your mysql query has a syntax problem. The resultset ( $result2 ) is a boolean false because the statement does not execute, not a reocrdset.