litle "condition" problem

[vinny199]

Hi,

I'm having problem printing on a page "there are no pending jobs waiting to be aproved" when my recordset does not return any value.
I explain:

Here is my recordset

SELECT *
FROM job
WHERE (TO_DAYS(b) - TO_DAYS(NOW()) > 0) AND job.status='To Be Confirmed'
ORDER BY job.b ASC ,  job.hours ASC ,  job.minutes ASC

And all works perfectly well.
It's just that when there are no jobs in the database with the $status = 'To Be Confirmed' I'd like to echo a asimple line of text instead of just a blank page saying:

'There are no pending jobs to be aproved'

I used the following below, but thats obviously not quite right...

<?php 
if ( !empty($row_rsjob['status'])  ) 
{ 
    echo 'There are no pending jobs to be aproved.'; 
} 
?>

Any idea?

Cheers,

V.

[bpat1434]

well, just use the [man]mysql_num_rows/man function to determinte how many rows were returned (0 = no pending, >0 = pending).

And your current code says:
IF NOT EMPTY $current_row['status']: print "No pending jobs".

~Brett

[kiropyckoticks]

To further help you in debugging, you can turn on the NOTICES on PHP. this will report to you any errors, warnings etc. example warning is if you do not set a variable and then tried to use it.