Quick Question: "False" assignments

[Haleden]

while ( $category_array[] = $db->sql_fetchrow($result) ); 

I think you all can pretty much figure out what this is.

Why is it that when $db->sql_fetchrow() returns FALSE, it is stored in my category array? Shouldn't it stop when it returns false?

[sweatje]

Nope, php is doing exactly what you ask:
evaluate $db->sql_fetchrow($result)
store the result as the last element of $category_array
check that same value, if false (or null or empty string or 0) continue on past the while loop

[DougBTX]

It stops when the whole expression $category_array[] = $db->sql_fetchrow($result) evaluates to false; by this time false has already been added to your array.

Douglas

[Haleden]

Ah... okay. Darn, thats a doosey.

[arborint]

Wasn't there a thread a while back about some of the time travel functions in PHP? Perhaps one of these could be used to alter the execution of the script between the fetch and the assignment.

[seanf]

Moved to a more appropriate forum. See Where should I post my thread? for details

Sean

[Young Twig]

Just change it to:

while($row=$db->sql_fetchrow($result))
    $catergory_array[]=$row;