Trouble with DB results

[Nolan]

Hello.

First let me say that I haven't messed around with PHP for quite some time. I used to be fairly good with the language around 10 years ago but stopped programming until recently again.

I love how you made a pretty nice user system here and I thank you for that.

I am having trouble with getting results from the query though... Here is what the page looks like.



and here is the code I have...



I tried doing mysql_num_rows but I couldn't get a count on the rows that way either.


Any help would be of great help.

Thank you!

[mudmin]

It's been a little while since I've used the count method, so I had to confirm. I put a method in the db class that does this for you. You can do something like this.

Code:

$query = $db->query("SELECT * from users");

Code:

$count = $db->count();

Code:

echo $count;

You can also see that kind of coding in action at the top of the admin panel. I hope that helps.