Select * users question

[Eggzorcist]

I have a question concerning outputting information taken out of the database.

 

Query is as follows:

 

$query = "SELECT * FROM users";
	$results = $this->db->query($query);
	$result = $results->fetch_assoc();

	return $result['username'];

 

 

The value that returns is the first username in the database. But here I am selecting all the usernames, can I select others ones with the fetch_assoc?

[Maq]

Look at Example #2:

http://us3.php.net/mysql_query

 

You need to loop through the result set, usually using a while loop.