adding $result to an array

Anon

I want to be able query my DB and place the results in an accessible array.

For example

SELECT * FROM email ...

$SQL_query = mysql_query($SQL, $db);
while ($myrow = mysql_fetch_array($SQL_query))
{$id = $myrow['email'];
print("$id\n"); ....

Now, what is the best way to access all the rows that are executed? Can I put them in an accessible array?

Thanks

Mark

trooper

Mark

I have just been doing this so it is quite fresh in my mind. here is my code

function find_users_email($sql)
{
$result = mysql_query($sql);
$num_rows = mysql_num_rows($result);

while ($i <$num_rows)
{
$row = mysql_fetch_array($result,$num_rows);
$email_list[$i] = $row[email];
$i++;
}
return $email_list;
}

then in the page you want display the results i had the following

while($i < sizeof($email_list))
{
print "<br>$email_list_1[$i] ($i)<br>";
$i++;
}

if you have any questions just ask away!

trooper

oops sorry i gave you dodgy code there the code on the page youwish to display your array is as follows

$email_list = find_users_email("SELECT * from users where email not like '%aardvark%'");
$i=0;
while($i< sizeof($email_list))
{
print "email list $email_list[$i] element $i<br>";
$i++;
}

soz about that

Anon

Thanks -
I know I'll have more questions.