could use some help with foreach problem

[roman_dolan]

I am trying to step throgh an array using foreach, but I am not getting it right so advice would be appreciated.
I have simplified this
I have pulled some data into an array from MySQL using

$row= @mysql_fetch_array;
and the array looks like

( [0] => user1 [user_id] => user1 [1] => test [dept] => test [2] => 3 [section] => 3 [3] => 20040422210535 [date] => 20040422210535 )

I try to step through it using

foreach($row as $value){

echo $value["user_id"];
echo $value["dept"];
echo $value["section"];
echo $value["date"];}

but the output is:

u
u
t
t
3
3
2
2

clearly I'm getting something very wrong

[sidney]

mysql_fetch_array give an array with assocative keys and numeric keys so there is two values for each value

use mysql_fetch_row for numeric key array

or mysql_fetch_assoc for an associative key array

[LordShryku]

Though the loop could be done at the same time as well....

while($row = mysql_fetch_array($result)) {
   echo $row['user_id']."<br />".
        $row['dept']."<br />".
        $row['section']."<br />."
        $row['date'];
} 

[roman_dolan]

Thankyou both. Will try

ps
have been using while but I now need to put a counter in for each row hence wanting to use foreach

regards