PHP - Column names in array

[cancer10]

ok, see the code below

<?
$rsQry = mysql_query ("select * from tblCustomer");
$arrQry  = mysql_fetch_row($rsQry);
?>

Now if I try to fetch a Customer's Name from the "Customer_Name" column from the "tblCustomer" table with the following code then I dont get anything:

<?
echo $arrQry["Customer_Name"];
?>

Why?

PS: I have tried this way and it works:

<?
echo $arrQry[0];
?>

But I want to use the column name instead of the column number. Any idea?

Thanx

[stymiee]

$arrQry  = mysql_fetch_array($rsQry);

[dr4g]

What you're wanting to do is use an ASSOCiative array.
Theres 2 methods of doing this.

mysql_fetch_array($rsQry, MYSQL_ASSOC);

or

mysql_fetch_assoc($rsQry);

[omick16]

while ($row = mysql_fetch_array ($result))
{
echo "$row";
echo "$row[1]";
}

the second argument is kinda optional... :)