On Sat, Feb 13, 2010 at 3:26 AM, Paul <devine...@msn.com> wrote:

> Hi all,
>
> I'm currently having a problem correctly formatting a table within a while
> loop.  I'm using an object to store the results of a query, and using the
> while to iterate through it each row to produce the output:
>
> $query = "SELECT * FROM foo WHERE UserID = " .$uID . " ORDER BY bar";
> $result = mysql_query($query);
>
> while($obj = mysql_fetch_object($result))
> {
>        $obj->bar;
> }
>
> To properly format the table, I need to check the value of bar in the next
> iteration of the object (but have to do it on the current one). Using an
> array, I would do:
>
> next($obj);
> if($obj["bar"] == "something")
> {
>        //do things
> }
> prev($obj);
>
> Is there an equivalent to object?  I've tried the above method, but nothing
> happens.  I've also tried type casting it to an array, without success.
>
> Is there anyway to iterate through this?
>

Paul

Is this the one you want ?

$sql = 'select id, name from test';
$result = mysql_query($sql);
$rows = array();
$row = null;
while ($row = mysql_fetch_object($result))
{
    $rows[] = $row;
}

reset($rows);

for ($i = 0, $c = sizeof($rows) - 1; $i < $c; $i++)
{
    next($rows);
    if (current($rows)->name)
    {
        // something to do
    }
    prev($rows);

    echo current($rows)->id, ' ', current($rows)->name, "\n";

    next($rows);
}

if (current($rows))
{
    echo current($rows)->id, ' ', current($rows)->name, "\n";

}

Regards,
Eric,


> Thanks,
> Paul
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

Reply via email to