Prev: php_warn
Next: Getting total quantities
From: Moritz Fuchs on 13 Feb 2010 03:54
Hi,

Why don't you just try the following:

$query = "SELECT * FROM foo WHERE UserID = " .$uID . " ORDER BY bar";
$result = mysql_query($query);

//get the first row
$row = mysql_fetch_object($result);

//get the next row
while ($next = mysql_fetch_object($result)) {
//do something with row/next

//The next row is the current row in the next iteration
$row = $next;
}

mysql_free_result($result);


Regards
Moritz

On Fri, Feb 12, 2010 at 8:26 PM, Paul <devineman(a)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?
>
> Thanks,
> Paul
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
From: Richard Quadling on 13 Feb 2010 15:54
On 12 February 2010 23:46, Paul Hollingworth <devineman(a)msn.com> wrote:
> Thanks for the code Eric, it seems to loosely provide the functionality that
> I'm after.
>
> Just out of interest though, is there no other way to find the next result
> row in an object apart from dumping it into an array?
>
> Thanks,
> Paul

You can use mysql_result()
(http://docs.php.net/manual/en/function.mysql-result.php) to read a
specific row from the result set.

But you could also use the SQL WHERE or LIMIT clause to only retrieve
the specific row or rows you wanted.

--
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling
First  |  Prev  | 
Pages: 1 2
Prev: php_warn
Next: Getting total quantities