Posted by deko on 06/09/06 09:50

I'm trying to select a few rows:

$db = mysql_connect('localhost','userID','passwd');
if ($db)
{
$sql = "select cat_ID, cat_name from categories where category_count > 0";
mysql_select_db('dbName');
$result = mysql_query($sql);
$arrayCat = mysql_fetch_array($result);
}
mysql_close;

echo count($arrayCat); //count = 4

foreach ($arrayCat as $cat)
{
// this will iterate 4 times
echo "<br>".$arrayCat["cat_ID"]; // = 1
echo "<br>".$arrayCat["cat_name"]; // = test
}

what I don't understand is I get an array count of 4, but if I look in the
table, I see only 3 rows that meet the select criteria. Furthermore, why does
each iteration echo the same thing:

1
test
1
test
1
test
1
test

Am I using mysql_fetch_array wrong?

Thanks in advance.

[Back to original message]