php - Change only one value of an array returned by sql

Solution:

You can insert an entire PHP block inside eachtd element. Create a function that does the converting from 1490 to 149, let's call itconvert() in this example

<td align="left" class="page_speed_134481478">
    <?php
        if($rr['plan_duration'] == 1490)
        {
            echo convert($rr['plan_duration'])  
        }
        else
        {
            echo $rr['plan_duration'];
        }
    ?>
</td>
Copy code

You can also use the? conditional to reduce the amount of code:

<td align="left" class="page_speed_134481478">
     <?php echo ($rr['plan_duration'] == 1490) ? convert($rr['plan_duration']) : $rr['plan_duration'];
</td>
Copy code

Note: Besides usingmysqli instead ofmysql I strongly advice you to use Prepared Statements too

Solution:

Inside yourwhile loop you can just use anif statement.

<td align="left" class="page_speed_134481478">
    <?php  if  ($rr['plan_duration'] == 1490) {
        echo 149 ;
    } else {
        echo $rr['plan_duration'];
    } ?>
</td>
Copy code

Solution:

I rewrote your code a bit to make it a bit better to read. I added a shorthand if statement. Take a look:

<?php
$result = mysql_query("SELECT * from memship_plan where status='1' order by plan_amount DESC");

$results = array();
while($record = mysql_fetch_array($result)) {
  $results[] = $record;
}
?>

<?php foreach ($results as $rr): ?>
<tr height="30px">
  <td align="left" ><?= $rr['plan_name']; ?></td>
  <td align="left" ><?= $rr['plan_contacts']; ?></td>
  <td align="left" >Unlimited</td>
  <td align="left" ><?= $rr['video']; ?></td>
  <td align="left" ><?= ($rr['plan_duration'] == '1490') ? '149' : $rr['plan_duration']; ?></td>
  <td align="left" >Rs. <?= $rr['plan_amount']; ?></td>
  <td align="left" ><a href="pay.php?plan=<?php echo $rr['plan_name']?>">Pay Now</a></td>
</tr>
<?php endforeach; ?>
Copy code

Solution:

<?php
$result = mysql_query("SELECT * from memship_plan where status='1' order by plan_amount DESC");
while($rr=mysql_fetch_array($result)) {
?>
<td align="left" class="page_speed_134481478">
    <?php  if($rr['plan_duration']=='1490') {
        echo "149";
    } else {
        echo $rr['plan_duration'];
    }
    ?>
</td>
<?php } ?>
Copy code