mysql_fetch_array

[Anon]

I understand how the fetch_array works, it moves to the next row and builds an array. However, I am calling a certain record based on a username and when I call it through my query it catches that record and then the fetch_array moves it to the next record and screws everything up. Is there another function that will grab that record and give it to me?

[Anon]

Nevermind, I think I got it. A total 'fer duh' on my part.

[Anon]

Yes u can use mysql_fetch_row function.

$query = "select fieldname1, fieldname2 from sometable ";

$result = MYSQL_QUERY($query);

while(list($fieldsname1, $fieldname2) = mysql_fetch_row($result))
{
echo $fieldname1 $fieldname2;
};

This should work..

Chanderjit