[RESOLVED] while help

[Phoenix_Down]

This is how I retrieve my table field data:

                $query= mysql_query("SELECT * FROM cphelp");
                list($one, $two, $three, $four, $five, $siz, $seven, $eight, %ten, $eleven, $twelve, $thirteen, $fifteen, $sixteen) = mysql_fetch_row($query);

How can I do a loop to retrieve all rows by using $one, $two, etc. instead of $whatever[1], etc.?

Any help will be greatly appreciated.

[laserlight]

Use a while loop, e.g.,

while (list($one, $two, $three) = mysql_fetch_row($query))
{
    echo $one . $two . $three;
}

Of course, note that this can be rather inflexible as compared to:

while ($row = mysql_fetch_row($query))
{
    echo $row[0] . $row[1] . $row[2];
}

Since you must match your list() with the columns selected. Also, it is better to select the columns you need, then access them by name, e.g.,

while ($row = mysql_fetch_assoc($query))
{
    echo $row['item'] . $row['price'] . $row['quantity'];
}

As this provides more context as to what is being processed.

[Phoenix_Down]

Thank you, lazerlight. You really helped me out a lot.