Array

[bdata28]

I would like to create an array based on a select statement. Is this possible?

Example:

select usename from users

recordcount = 3

I want the array to contain the user names

$my_array = array(username1, username2, username3)

I'm thinking that I need to loop through each one of the records and then assign it to a variable and then build the array based on the variables. Any ideas?

I'm hoping I'm just having a complete brain meltdown in not being able to figure this out.

Thanks!

[sarahk]

for starters your resultset is an array already but you can also loop through

$my_array = array();

then loop through the resultset with, say $i as the pointer

and $my_array = $db->record["username"];

or however you access your data with your database.

[rinjani]

$query = "SELECT STATEMENT";

$result = mysql_query($query) or die("Error in query");

while ($my_record = mysql_fetch_array($result)) {

$my_array[] = $my_record;

		}

And you can print it out to make sure there's something in there with:

for ($i=0; $i>sizeof($my_array);$i++) {

HTH

[rinjani]

Sorry, I was cut off in the middle

And you can print it out to make sure there's something in there with:

for ($i=0; $i>sizeof($my_array);$i++) {

 echo $my_array[$i];

}