[SOLVED] Can I create arrays in loops?

[mazman13]

Will something like this work to create an array in a loop?

 

 $query = "SELECT DISTINCT writer FROM data";
$result = mysql_query($query)
	or die ("Can't do anything with the query!");
while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
extract($row);
$servicewriters = array($writer);	
}
echo"$servicewriters[1]";

[micah1701]

it should work but you'll re-write the array each time you go through the loop.

 

why not test it and see what it does?

[kenrbnsn]

That will not do what I think you want, which is probably an array holding all the values of the field "writer" in the selected rows.

 

This code will do that:

 

<?php
$query = "SELECT DISTINCT writer FROM data";
$result = mysql_query($query)
	or die ("Can't do anything with the query!");
        $servicewriters = array();
        while ($row = mysql_fetch_assoc($result))
               $servicewriters[] = $row['writer'];
echo '<pre>' . print_r($servicewriters,true) . '</pre>';
?>

 

Ken

[mazman13]

It works! Thanks!