[RESOLVED] Using count for an array

[MitchEvans]

I have an array that I need to count how many times the id is printed. When I use the count below i just get the value of 1. Any ideas guys thanks for looking!

$directory = "SELECT * FROM directory WHERE authorised = 'Y'";
$directoryResults = mysql_query($directory);
while ($directoryRow = mysql_fetch_array ($directoryResults)){
$id = $directoryRow["id"];

echo $id;
}
echo count ($id);

[Piranha]

First you should use SELECT id FROM... if you only want to use the id.

Second, I can't see any reason to count how many times the id have been printed if you echo it in every row. Instead use [man]mysql_num_rows[/man] to see how many rows are returned from the query.

Third, if you really need to have a counter just do a counter that adds 1 every loop. Use $count++ or something like that.

[MitchEvans]

Ahhh my code is a lot more complicated than that, I thought I would just upload a simple example and hopefully get the answer from that. Unfortunately I can't do your first two ideas due to IF's and other criteria needed, so I'm going to use the count++ that you have suggested.
How would I use that on the example above then?

Thanks Piranha Lovin the help!

[Piranha]

K, then I understand. I didn't mean to be an ass about it, it is just that a lot of people are posting without knowing what they need, I thought that you were one of those. But fortunatley you are not.

You won't like the code when you see it, it is so simple that you won't understand why you didn't think of it yourself.

// Query and getting results
$count = 0;
while (results from query)
{
    if (should be counted)
    {
        $count++;
    }
}
echo $count;

[MitchEvans]

Yeah I can just imagine what some would be like. The code works great now! Thanks for the help Piranha, will try and post more difficult in depth answers in the future hehe, Many Thanks!