[ILUG] fetch_row problem

[Niall James O'Higgins]

On Sat, Mar 27, 2004 at 11:00:35PM +0000, nils wrote:
> hi,
> 
> while(list($topic_id, $forum_id, $topic_last_post_id, $topic_title,
> $topic_poster, $topic_views, $topic_replies, $topic_moved_id) =
> mysql_fetch_row($result));

<snip>

Seems to me like a funny place to put the list() construct.

Assuming data is actually in your result set (which it seems to be),
try something like this instead:

while($row = mysql_fetch_row($result)) 
{
    list($topic_id, $forum_id, $topic_last_post_id, $topic_title, 
            $topic_poster, $topic_views, $topic_replied,
                $topic_moved_id) = $row;
    echo "topic id: $topic_id";

    // etc
}

-Niall.


-- 
njo at sig11.com
------------------------------------------------------------
"It's not jingoism, and the only people who use that word are fifth columnists"
		-- Ann Coulter (http://www.frontpagemag.com/)