select data from 2 table

$sql="SELEC开发者_StackOverflow中文版T * 
            FROM jobs 
      INNER JOIN job_resp ON jobs.job_id = job_resp.job_id 
           WHERE jobs.job_id = $job_id";

Is this query is correct?

---

mysql_query() will return FALSE on error. check out http://php.net/manual/en/function.mysql-query.php

I think in your case, no result returned is not necessarily to be an error. Therefore you can see no data showing plus the "successful" notice.

---

First of all your code is vulnerable to sql injection

$job_id=$_GET['job_id'];

// should be
$job_id=(int)$_GET['job_id'];
// or
$job_id=mysql_real_escape_string($_GET['job_id']);

depending on the data type of jobid.

Also you are echoing rows before you declared it, so it wont work. it seems like it should be inside the while loop

<?php

echo "<ul>";
while($rows=mysql_fetch_array($result))
{
    echo "<li>".$rows['job_res']."</li>";
}
echo "</ul>";

---

try to use below query:

$sql="SELECT j.*, jr.*
            FROM jobs as j
      INNER JOIN job_resp as jr ON j.job_id = jr.job_id 
           WHERE j.job_id ='".$job_id."'";

But you should avoid *, try to use field name as j.id, j.job_titel etc.