[PHP-DB] mysql_num_rows

[LSC Exhibits Department]

I'm getting a strange error message from calling this function 

It spits out <Unknown column 'Resource' in 'field List'>
This is my query:

Advertising

SELECT dept.name, count(maintenance.deptid)/$total AS percentage FROM
maintenance
JOIN dept WHERE maintenance.deptid=dept.deptid GROUP BY dept.name

This query runs fine in console I just can't get mysql_num_rows to return a
value.

This is running mysql 4.0.3 and php 4.2.3

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php