array not picking up all keys

[Anon]

I have a select statement that queries a table.

I can count the rows and get a good return:
echo(mysql_num_rows($result)); //=2rows

I put the results in to an array:
$row=mysql_fetch_array($result);

I can see the first element of the array:
echo("$row[0]"); //shows the first value

But I can't see the second element:
echo("$row[1]"); //no return

I tried putting more records in to my table, but nothing shows past the first element.
Can someone give me a hint on this one?

thanks

[Anon]

Show us the statement and content of the table.

[Anon]

Use mysql_fetch_row instead...

$row = mysql_fetch_row($result);

Well, wait a second. Are your trying to get multiple records or multiple columns? My better judgement says records... In that case, the quick fix is...

for($loop=1; $row=mysql_fetch_row($result); $loop++😉
{
echo "Do this and that until you get sick of playing with your rows of data.";
}

When you use mysql_fetch_array it does not grab multiple records/rows. I assume that is what you had thought it was doing. Check out this address for more complete info on the function.

http://www.php.net/manual/en/function.mysql-fetch-array.php

You could always build an array inside your loop, but typically it is unnecessary.

Aaron Zoller
www.AaronZoller.com (Opening June 02)