Best way to do this...

[eluser]xwero[/eluser]
This means there is something in the sql statement that wasn't found in the table. Is there an entry with the id 2?

[eluser]Chris.Campbell[/eluser]
I fixed the problem. count_comments was set to "null", I switched it to "not null" and it now works Thanks for the help on that part!

[eluser]Chris.Campbell[/eluser]
How do you grab something from the database, and display it without having to loop through the results?

[eluser]gtech[/eluser]
print_r($databasequery->result_array());

if you want a quick debug

[eluser]Chris.Campbell[/eluser]
Thanks everyone got it all working Ill be back though Haha

[eluser]Derek Allard[/eluser]
Glad you got it Chris. I look forward to you sharing your experience on these forums with other users who need help.