Mysql query fails :/

[Utherr12]

http://pastebin.ca/1992678php gives me this error: "Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in D:\webserver\blogger\index.php on line 98 " (it's line 5 on pastebin)If i copy paste that sql query into a client and execute it, it works just fine :/... i really don't know what's the problem here.What I'm trying to do here: I want to group all the posts my DB contains into pages starting from most recent to the oldest, and then display all the pages that exists.

[justsomeguy]

Check for errors from MySQL and print them:mysql_query(...) or exit(mysql_error())In this case, it's probably complaining about the semicolon. You can't send multiple queries to MySQL with one call to mysql_query, so it doesn't expect a semicolon at the end.

[Utherr12]

Omg...forgot to select the database ... i have two php scripts on my page, i only selected the db in the first script.