2 Different Mysql Tables

[didgydont]

hi all

 

I have two tables on a job board

1st table like so "custid,customer,duedate,statusid"

the status is just an id wich refrences the second table

2nd table "statusid,stutus,hidden,completed"

 

at the moment i have

 

select * from jobs

then

if (!functiontocheckifcomplted($row[statusid])==true)

{

then display stuff here

}

 

but it still reads evey mysql job is there a better way to do this ?

[Barand]

Do the completed check in the query

 

SELECT custid, customer, duedate, statusid
FROM table1
INNER JOIN table2 USING (statusid)
WHERE table2.completed

[didgydont]

Thank you what you suggested did not work for me but you pointed me in the right direction

mysql_query("SELECT * FROM jobs INNER JOIN statuses ON jobs.status=statuses.id WHERE statuses.completed = '0' ORDER by jobs.duedate");