Warning: mysql_num_rows() expects parameter 1 to be resourc

[simplypixie]

The error means that your query is failing (so there are no rows to count) so echo out your $sql and see what exact query it is trying to run on the database and make sure it is correct (if you think it looks correct then copy and paste into PHPMyAdmin and see what error you get there).