Is there any Good Tutorial on Class

Hi, I would like to know if there is any comprehensive tutorial ans examples on using class to manipulate MYSQL database. I have found some on the net but what these tutorials give are simple manipulations which only return one row of results.

Thanks for help!

 

To return multiple rows, in most cases you will need to do a "while" loop.

$sql = new db();
while ($row = $sql->db_Fetch()) {
	echo $row['column'];
}

Code (php):

This is example of the e107 mysql class, this should work for most other class, as it's structure depends on php mysql.

 

Thanks, but then it can only returns one column. In fact, what I usually do is something like that. Say there are two columns, one is the url of a website and one is the website name. Is there an class such that I can get all the arrays of

 

I think your sql only selects one column, what you want is
SELECT * FROM table_name
or
SELECT col1, col2 FROM table_name

 

I think I understand what you mean. Let me do a quite study on that. Thanks!