unidox Posted April 14, 2008 Share Posted April 14, 2008 I keep getting not a valid mysql resource. Here is my code: $q = mysql_query("SELECT * FROM `pcp_users` ORDER BY 'user_id' DESC WHERE level >= '$lvl' AND level != '1' AND username != '$user' AND conf = '1' LIMIT $start, $limit"); Quote Link to comment Share on other sites More sharing options...
kenrbnsn Posted April 14, 2008 Share Posted April 14, 2008 We need to see more of your code. Where are you getting the error? How are the variable set? You should also separate the query sting from the query call, so you can do some debugging: <?php $q = "SELECT * FROM `pcp_users` ORDER BY 'user_id' DESC WHERE level >= '$lvl' AND level != '1' AND username != '$user' AND conf = '1' LIMIT $start, $limit"; $rs = mysql_query($q) or die("Problem with the query: $q<br>" . mysql_error()); ?> Ken Quote Link to comment Share on other sites More sharing options...
unidox Posted April 14, 2008 Author Share Posted April 14, 2008 Well I have figured out you cant use ORDER BY and LIMIT in the same query. Anyone know an alternative? Quote Link to comment Share on other sites More sharing options...
discomatt Posted April 14, 2008 Share Posted April 14, 2008 You can't? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.