[Resolved] Array index from MySQL Query

[ethought]

I am pulling info from my database with and have the following code...

$row = mysql_fetch_row($result);
$smarty->assign('department', $row[3]);

This works fine. However, if I use $row['department'], where department is a column defined in my database, I get the following error...

Notice: Undefined index: department in C:\Documents and Settings\gthought\public_html\anykey\employeelookup.php on line 24

I checked for typos to make sure I spelling department correctly in my table and in the php code, but all looks well from my end. Is there something else I am doing wrong?

Thanks.

[laserlight]

You should use mysql_fetch_array() or mysql_fetch_assoc() instead.

[ethought]

Thank you very much.