storing into vars

for storing info into the

Code:

var $var;

i have seen this done both ways and wondered is there a advantage on one over the other?

is it better to do it

Code:

$this->zname = mysql_result($zinfo_res, 0, "name");

or

Code:

$obj = mysql_fetch_object($zinfo_res);
$this->zname = $obj->name;

[Join us @ facebook]

Using class variables is good only if you are going to reuse that data in many functions of the class. Otherwise it looks more like spending too much memory.

yeah the data is going to be used in about 3-4 functions currently, but is there a benefit for using one of them styles to store the data or the other?

Use mysql_fetch_object if you want the whole set of column data to stick around as a group for processing now or later. Use mysql_result if you only want specific columns, or if you want to process the values in PHP (rather than in SQL) before constructing your object.

[Guest]

[36.176]

Yahoo crawler, Googlebot, Gigabot, realmadvert, Baidu Spider