MySql Class

hollen949b · **hollen949b**, WDF Noob Home page Private message

How would I go about getting the same results from

PHP How do I post PHP blocks?

class newCats { public $go; private $id; public function __construct() { $this->go = uniqid(); } public function listData() { return "id: {$this->id} go: {$this->go}"; } } $result = mysql_query( "SELECT * FROM wr_categories ". "ORDER BY ordering" ); while($obj = mysql_fetch_object($result, 'newCats') ){ echo $obj->listData()."<br /> \n"; }

but putting

PHP How do I post PHP blocks?

$result = mysql_query( "SELECT * FROM wr_categories ". "ORDER BY ordering" );

in its own function within my newCats class?

hollen949b · **hollen949b**, WDF Noob Home page Private message

In my defense it was late when i posted this question .... tah timmahhh!!!

PHP How do I post PHP blocks?

class newCats { public $go; private $id; public function __construct() { $this->go = uniqid(); } public function listData() { return "id: {$this->id} go: {$this->go}"; } public function select(){ return mysql_query( "SELECT * FROM wr_categories ". "ORDER BY ordering" ); } } $qry = new newCats(); $result = $qry->select(); while($obj = mysql_fetch_object($result, 'newCats') ){ echo $obj->listData()."<br /> \n"; }

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Add, View, Edit & Delete from to MySQL database, Live Example (News System)	making	MySQL and MaxDB	7	January 5 '09 10:59 AM
Class Object in Session vs Load time	toadeny	PHP	1	October 5 '04 01:51 PM