how to execute two while loop at same time in php?

Question

I am displaying data from database in a table.
In the table I have tr tags and in the tr tag I have two td tags.

Here is code.

<table class="rag_table" rules="all">
<tr><th><font size="5">Technical Events</font></th><th><font size="5">Non-technical events</font></th></tr>
<?php
$query="SELECT id,name FROM event_content WHERE have_img=1";
$havepage=mysql_query($query);
$query1="SELECT id,name FROM event_content WHERE have_img=0";
$havepage1=mysql_query($query1);
?>
while ($row=mysql_fetch_array($havepage)) {
    ?>
    <tr><td><a href="robo_race.php?eve=eve$evt_id=<?php echo $row['id'];?>"><font color="#FC2B5F"><?php echo $row['name'];?></font></a></td>
    <?php
}
while ($row1=mysql_fetch_array($havepage1)) {
    ?>
    <td><?php echo $row1['name'];?></td></tr>
    <?php
}
?>
</table>

What I want exactly is that the left td tag must display the have_img=1 values and the right td tags must display the have_img=0 values. i want to display like...

Please help me.

Edwin Thomas · Accepted Answer · 2015-08-22 11:39:32Z

3

Try this...

<table class="rag_table" rules="all">
    <tr>
        <th><font size="5">Technical Events</font></th>
        <th><font size="5">Non-technical events</font></th>
    </tr>
    <?php
    $query="SELECT id,name FROM event_content WHERE have_img=1";
    $havepage=mysql_query($query);
    $query1="SELECT id,name FROM event_content WHERE have_img=0";
    $havepage1=mysql_query($query1);
    while ($row=mysql_fetch_array($havepage))
    {
    ?>
        <tr>
            <td>
                <a href="robo_race.php?eve=eve$evt_id=<?php echo $row['id'];?>"><font color="#FC2B5F"><?php echo $row['name'];?></font></a>
            </td>
        <?php
        $check_right_td=0;
        while ($row1=mysql_fetch_array($havepage1))
        {
            ?>
            <td>
                <?php echo $row1['name'];?>
            </td>
        </tr>
        <?php
        $check_right_td=1;
        break;
        }
        if($check_right_td==0)
        {
        ?>
            <td></td>
        <?php
        }
    }
    ?>
</table>

edited Aug 22, 2015 at 11:39

answered Aug 22, 2015 at 11:18

Edwin Thomas

1,1942 gold badges18 silver badges33 bronze badges

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

2 Comments

Divyesh Jesadiya Over a year ago

it is nice but it's breaking my table if there is not right td=left td.

Divyesh Jesadiya Over a year ago

or see image of result i want to like.

Viral · Accepted Answer · 2015-08-22 11:07:06Z

2

Try fetching data in one query instead of two, and try to manipulate in your loop,

$query="SELECT id,name FROM event_content"; // will get you have_img=1 and have_img=0

Let the query go and get results,

while($row=mysql_fetch_array($havepage)) {
    $res[] = $row; // collect the mysql data in array
}

Use condition as your application structure,

foreach($res as $record)
{
    // echo something common in both cases    

    if($record['have_img'] == 1)
    {
        // echo something for have_img=1
    }
    if($record['have_img'] == 0)
    {
        // echo something for have_img=0
    }
}

answered Aug 22, 2015 at 11:07

Viral

3,7531 gold badge20 silver badges34 bronze badges

Comments

Dharmesh Vasani · Accepted Answer · 2015-08-22 11:04:32Z

1

<table class = "rag_table" rules = "all">
<tr><th><font size = "5">Technical Events</font></th><th><font size = "5">Non-technical events</font></th></tr>
<?php
$query = "SELECT id,name,have_img FROM event_content WHERE have_img IN (0,1)";
$havepage = mysql_query($query);

while ($row = mysql_fetch_array($havepage)) {
    $leftTd = $rightTd = '';
    if ($row['have_img'] == 1) {
        $leftTd = $row['name'];
    } else {
        $rightTd = $row['name'];
    }
    ?>
    <tr>
        <td>
            <a href="robo_race.php?eve=eve$evt_id=<?php echo $row['id']; ?>">
                <font color="#FC2B5F"><?php echo $leftTd; ?></font>
            </a>
        </td>
        <td>
            <a href="robo_race.php?eve=eve$evt_id=<?php echo $row['id']; ?>">
                <font color="#FC2B5F"><?php echo $rightTd; ?></font>
            </a>
        </td>
    </tr>
    <?php
}
?>

answered Aug 22, 2015 at 11:04

Dharmesh Vasani

4752 gold badges5 silver badges20 bronze badges

2 Comments

Divyesh Jesadiya Over a year ago

it is display like if left td is there it won't display right td for that tr tag. i want it like see image that i just add.

Dharmesh Vasani Over a year ago

I cannot find your image.

Collectives™ on Stack Overflow

how to execute two while loop at same time in php?

3 Answers 3

2 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related