Duplicate Results

[zed420]

Hi All

Can some please tell me what is wrong with this query it's bringing out the Duplicate results according to $pagesize . As it is now it's bringing out same result three times.  Why???  I have inserted the query into phpMyAdmin its working fine bringing out one result.  Some help will be greatly appreciated. Thanks

 $pagesize = 3; 
$recordstart1 = (isset($_GET['recordstart'])) ? $_GET['recordstart'] : 0;
$query1 = "SELECT  * FROM job_tb,user  
WHERE job_tb.status = 'No' OR 
job_tb.cust_address = 'Cancel' AND 
user_id = id
ORDER BY job_id DESC LIMIT $recordstart, $pagesize";
$result1 = mysql_query($query1)or die(mysql_error()); 

Thank in advance

Zed

 

[Maq]

job_tb.user_id = user.id

[sasa]

and is evaluate before or

try

WHERE (job_tb.status = 'No' OR job_tb.cust_address = 'Cancel') AND user_id = id

[zed420]

Thanks for quick reply It didn't work still the same, coming out with three results.

 

Zed

[Maq]

Are there any other common fields between job_tb and user?

[zed420]

sasa YOU ARE A MAGIC MAN it worked, thank you

 

Zed

 

[zed420]

Maq thank you blue, all sorted

 

Many thanks

Zed