Need help with a small sql query

hi,

this query is working

$query="SELECT * FROM video ORDER BY addtime DESC LIMIT $limit";

Code (markup):

this gives: mysql_numrows(): supplied argument is not a valid MySQL result resource in...

$query="SELECT * FROM video ORDER BY addtime DESC LIMIT $limit WHERE active = 1";

Code (markup):

 

Hello

Your WHERE clause needs to be before your ORDER BY like this

SELECT * FROM tablename WHERE field1 = field2 ORDER BY .... LIMIT ....

Code (markup):

 

thank you. it is fine now.