Re: PHP Objects and SQL Results

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Paul,
Can't you just?

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

while($obj = mysql_fetch_assoc($result) {
	$bar = $obj['bar'];
	 if ($bar == "something") {
	 //do this
	}
}

I'm some what a beginner, so sorry if this wastes your time.


Karl


On Feb 12, 2010, at 1:26 PM, Paul 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


Karl DeSaulniers
Design Drumm
http://designdrumm.com


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux