How display php echo results in different styles?

Question

I have 2 php echo results from my mysql database. Their request is common and wrapped into one line :

$sql = "SELECT * FROM test WHERE id IN ('9','10')";

I want only the first result to be displayed in h3 style, and the second result to be displayed in normal p style. Using the code below the 2 results are displayed in h3 style.

How do I fix it ?

Thank you in advance.

enter code here

<div class="one-third wow fadeIn">
<span class="circle"><span class="ico pig"></span></span>
<h3>

<?php
$conn = new mysqli($dbhost,$dbuser,$dbpass,$dbname);
if ($conn->connect_error)
{
echo "connection error" ;
}

$sql = "SELECT * FROM test WHERE id IN ('9','10')";
$result = $conn->query($sql);

?>
<?php
if ($result->num_rows > 0) { while($data = $result->fetch_assoc())
{echo $data ['FR']."<br>"; }    } else {echo "---"; }?></h3>
<p>

K.B · Accepted Answer · 2017-11-13 12:00:58Z

1

Try this

    <?php
        $conn = new mysqli($dbhost,$dbuser,$dbpass,$dbname);
        if ($conn->connect_error)
        {
                echo "connection error" ;
        }
        $sql = "SELECT * FROM test WHERE id IN ('9','10')";
        $result = $conn->query($sql);
    ?>
    <?php
    $i = 0;
    if ($result->num_rows > 0) { 
            while($data = $result->fetch_assoc()){
                  if($i == 0){
                        echo "<h3>".$data ['FR']."<br></h3>"; 
                    }else{
                        echo "<p>".$data ['FR']."<br></p>"; 
                    }
                     $i++;
            }    
    } else {
        echo "---"; 
    }
    ?>

answered Nov 13, 2017 at 12:00

K.B

8855 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

isai61 Over a year ago

Yes, it's working, kranthi ! You're a chief ! Thank you. very much !

Collectives™ on Stack Overflow

How display php echo results in different styles?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related