jeudi 19 décembre 2019

php while loop condition inside if statement value

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