Help

[unidox]

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");

[kenrbnsn]

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

 

[unidox]

Well I have figured out you cant use ORDER BY and LIMIT in the same query. Anyone know an alternative?

[discomatt]

You can't?