mysql_fetch_array problem I

[Anon]

Hi!
I have two problems with a mysql-query:
I am trying to do a count and then fetch the number of results for this count. However, I can't figure out how to get the second number of the query for example. Here is my query:
$query1 = "SELECT COUNT(*) AS number FROM table WHERE catid='1' || catid='2' || catid='3' || catid='4' || catid='5' GROUP BY catid";
$result = mysql_db_query("$db", $query1);
I would know how to fetch all the numbers through a while-loop:
while ($r = mysql_fetch_array($result)) {
extract($r);
}
However, a while-loop won't help me here, because I need to place the numbers in different places. So I thought
$number[0] would return the first row of the array, but obviously it doesn't.
What am I doing wrong or what would be the right way to access this array?
Thanks in advance!
Sarah

[[deleted]]

$r=mysql_fetch-array($result)

gives you the next record in the resultset untill you run out of records.

But, you are not limited to fetching just the next record,
you can also define which of the records from the resultset you want to fetch next.

http://www.php.net/manual/en/function.mysql-data-seek.php

You can use mysql_data_seek() to move to record number X in your resultset.
So you can use mysql_num_rows() to get the number of records in your resultset, and use data _seek to move to each record when you want to fetch it.