Novice help with multi table database

[acesites]

Hi I hope someone can help, the code below checks for the sections I need, but I want it to exclude if the warehouse_id is deleted ( this is in another table 'damage_warehouses'  'deleted'=1 )

   

PHP Code: [Select]

//fetch the array of outstanding jobs 
$sql = mysql_query("SELECT id, warehouse_id, section, inspection_due, inspector, email FROM damage_warehouse_inspectionsections WHERE inspection_complete='0'");
while($result = mysql_fetch_array($sql))


Many thanks in advance

[RaythXC]

When you say warehouse_id is deleted, do you mean that particular field is empty? Also integers don't get ' symbols round them (assuming inspection_complete is an integer)

PHP Code: [Select]


$sql = mysql_query("SELECT id, warehouse_id, section, inspection_due, inspector, email FROM damage_warehouse_inspectionsections WHERE inspection_complete=0 AND warehouse_id>0");


If you mean check a different table, i'm unsure howto do that without a load of loops