Looping problem?

require 'database.php';
$t_02 = "subnets";
$sql_subs = mysql_query("SELECT * FROM $t_02",$db)or
die(mysql_error()); while(list($id,$sub,$msk,$dns01,$dns02,$rtrs,$rnge )
= mysql_fetch_array($sql_subs)) {
$num = mysql_num_rows($sql_subs);
for($z = 0; $z < $num; $z++) {
$vlans[] = "subnet $sub<br>netmask $msk {<br>option domain-name-servers
$dns01, $dns02;<br>option routers $rtrs;<br>range $rnge;<br>}<br>"; }
}
// Write everything out formated...
echo $vlans[$z]<br />\n;

Right now it only pulling the last record???
Jas

Jas wrote:
> require 'database.php';
> $t_02 = "subnets";
> $sql_subs = mysql_query("SELECT * FROM $t_02",$db)or
> die(mysql_error());
> while(list($id,$sub,$msk,$dns01,$dns02,$rtrs,$rnge ) =
> mysql_fetch_array($sql_subs)) {
> $num = mysql_num_rows($sql_subs);
> for($z = 0; $z < $num; $z++) {
> $vlans[] = "subnet $sub<br>netmask $msk {<br>option
> domain-name-servers $dns01, $dns02;<br>option routers $rtrs;<br>range
> $rnge;<br>}<br>"; }
> }
> // Write everything out formated...
> echo $vlans[$z]<br />\n;
>
> Right now it only pulling the last record???
> Jas
Try this instead using the mysql_fetch_array function:

require "database.php";
$query = "SELECT * FROM subnets";
$result = mysql_query();
while ($row = mysql_fetch_array($result)) {
... all your array vars are in $row[];
}

--

-Calico Jack-
http://www.scriptsharks.com/