This is probably more like what you need.
I can't see why you'd need to loop through your results using two different
methods (while and for)
require 'database.php';
$t_02 = "subnets";
$sql_subs = mysql_query("SELECT * FROM $t_02",$db) or die(mysql_error());
$num = mysql_num_rows($sql_subs);
for ($z = 0; $z < $num; $z++)
{
list($id, $sub, $msk, $dns01, $dns02, $rtrs, $rnge) =
mysql_fetch_array($sql_subs);
$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...
for ($z = 0; $z < $num; $z++)
echo "$vlans[$z]<br />\n";
Martin
> -----Original Message-----
> From: Jas [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 7 January 2004 9:05 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP] 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
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
