Database Question

[Anon]

Ok I got

$result = mysql_query("SELECT * FROM gallery");
$row = mysql_fetch_array($result);

and blah blah. There is a total of 66 rows in the table 'gallery' but when I try to print $row; for a simple experiment, it would return the number 8. Why's that?

[Anon]

I mean when I do the following:
$blah = count ($row);
print $blah;

would return the number 8.

And just typing:
print $row;

would return the word "Array"

why's that?

[rwilkerson]

$row only references the entire record which is returned as an array. Based on your post, I'm assuming you have 8 fields that are being returned (a count of the elements in the array). To get actual data, you need to reference $row['fieldName'].

Hope this helps.

[Anon]

I only have 66 records. Only 4 fields. I don't know where 8 comes from.

Rob Wilkerson wrote:

$row only references the entire record which is returned as an array. Based on your post, I'm assuming you have 8 fields that are being returned (a count of the elements in the array). To get actual data, you need to reference $row['fieldName'].

Hope this helps.