Below code will set statically now thats working here is fine
<?php
include "db.php";
$val = $_GET['id'];
$stmt = mysql_query("SELECT * FROM zones where region_name=$val order by zone_name ASC");
$s=0;
?>
<?php
while($row = mysql_fetch_array($stmt)) { $s++;?>
<?php if($row['zone_name']=='Zone 1'){?>
<option value="1">Zone 1</option>
<?php }elseif($row['zone_name']=='Zone 2'){?>
<option value="2">Zone 2</option>
<?php }elseif($row['zone_name']=='Zone 3'){?>
<option value="3">Zone 3</option>
<?php }?>
<?php } ?>
But I want to set in dynamically by using loop:
<?php
while($row = mysql_fetch_array($stmt)) { $s++;?>
<?php if($row['zone_name']=='<?php echo $s;?>'){?>
<option value="<?php echo $s;?>"><?php echo $s;?></option>
<?php }?>
Is It possible to work kindly give me a solution..
Aucun commentaire:
Enregistrer un commentaire