Hi I am searching a database and listing results by the highest number. It works ok but when a field lists over 100 it doesnt list it even it it is the highest? Any ideas?
Any help would be great!
Jules
Any code we can see?
$get_online= " SELECT * FROM $table_name WHERE (time) >= '$current' and (total_count) != '0' ORDER BY total_count DESC LIMIT 5 ";
Can you describe the fields in the table and where the "$current" comes from?
I don't see anything wrong with the sql! Do you have some while or for loop that is not working as it should? Show the full code, please!