So, I have a database (With a table called users) that let's users connect accounts, and it goes by their usernumber to find their accounts, let's say (With values):
Usernumber|Username|Email
-------------------------
1 | Justin | email@email.com
2 | Test | test@test.com
2 | Hi | gah@goo.com
1 | Foo | hey@hey.com
1 | Bar | Du@de.com
Now, in PHP, I do:
$stuff = mysql_fetch_array(mysql_query("SELECT * FROM users WHERE usernumber=1"));
Now, I do count($stuff);
and it returns 14, all the time, whether I do it with usernumber one or two... I can't figure out the problem, but I was wondering if someone else sees it, or knows something that I don't about how certain files are configured (Limits or something?). I'm using XAMPP to test everything right now.
ALSO, when I do the $stuff in PHPMYADMIN as a SQL in the table, it does return all the values it should.
So question is: What am I missing and how do I get it return all the values and not just 2 rows? (The table has 7 columns).
Thanks, Justin W.