mySQLi return array

[N-Bomb(Nerd)]

Hi,

 

I'm trying to write a function to read my database and return an array of names. I'm not very good because I've never really dealt with databases before.. here's the code I got so far.

 

<?php
function NameList() {
$query = "SELECT name FROM people";
if ($NameQuery = $this->db->prepare($query)) {
	$NameQuery->execute();

	while ($NameQuery->fetch()) {
		// something here I assume..
	}

	return $TheWholeListOfNames;
}
}
?>

 

I'm not just running into a problem and asking for help. I've actually tried searching this up and have been trial and error now for the last two hours.. finally gave up and asked for help.

 

Not quite sure where to go from here... would appreciate some help.

 

Thanks.

[DCRepairs]

Try this

 

<?php

$query1  = "SELECT * FROM people";
$result1 = mysql_query($query1);

while($row1 = mysql_fetch_array($result1, MYSQL_ASSOC))
{
echo "$row1['name']";
}
?>

 

Format the above code to fit in a table if you wish.