Query troubles \ question ..
 

i wanna count how many X items a user have.
so i set up this query:
and it gives all the items a the user have according to his userid..

now i want to count it... so how do i add to the query or count the number of item'sID with in the array which is formed?
i want it to have lika a varable, $total = (number of items found according to item's id).

hope i got it clear enough... :P

ok will this work?

mysql_num_rows( $result );

ok it will probably work... but, how can i create a multi-dimensional array from the result?

say it will return 3 rows, each row and its id number, so it will be like that:
is that even possible?

You can't turn a multidimensional array via MySQL. To answer your original question you'll need to use MySQL's COUNT() function like so:

[sql]
SELECT COUNT(*) as total FROM user WHERE userid = 1
[/sql]

aight thanks