PHP while loop split into two

Question

I'm running a while loop which is taking rows from mySQL and echo'ing them out. Pretty standard. However, there needs to be different HTML markup for the first item, next two items, then it continues as normal into the while loop.

Currently, my while loop looking something like this:

while( ( $row = mysql_fetch_object( $result ) ) !== false )
    {   

    // Places ad based of predefined variable frequency
    if ($ad == $adFrequency){

     echo '<div class="one-advertisement-article clearfix">';
     echo '<div class="grid_9 suffix_2"><img src="http://placehold.it/263x75/000000/ffffff"></div>';
     echo '<div class="grid_1"><a class="navigate-right-icon ss-icon" href="#">navigateright</a></div>';
     echo '</div>';

     $ad = 0;
    }

    echo '<div class="one-news-article clearfix">';
    if( $row->imagelibid )
            {
                $imageid = intval( $row->imagelibid );
                $image_result = mysql_query( "SELECT * FROM imagelib WHERE id = {$imageid}", $db );

                $image_row = mysql_fetch_object( $image_result );

                $image_url = "http://www.#.com/slir/w280/imagelib/" . $image_row->id . "_" . $image_row->filename;

                echo '<div class="grid_4"><a href="#"><img src="'.$image_url.'"></a></div>';        
            }
    else {
                echo '<div class="grid_4"><div class="news-placeholder"><span class="ss-icon">ellipsischat</span></div></div>';
        }

    echo '<div class="grid_7">';
    echo '<h2><a href="item-news.php?id='.$row->id.'">'.$row->title.'</a></h2>';

    $published_date = date('D, d M Y', strtotime($row->datein));
    echo '<p class="published-date">'.$published_date.'</p>';

    echo '</div>';
    echo '<div class="grid_1">';
    echo '<div class="news-item-vertical-sep">&nbsp;</div>';
    echo '<p></p>';
    echo '</div>';
    echo '</div>';

    $ad++;

    }

This works fine, but I need to take the first three news items and use this:

echo ' <div class="one-news-featured-article clearfix">';
    echo '  <div class="grid_12">';

    if( $row->imagelibid )
            {
                $imageid = intval( $row->imagelibid );
                $image_result = mysql_query( "SELECT * FROM imagelib WHERE id = {$imageid}", $db );

                $image_row = mysql_fetch_object( $image_result );

                $image_url = "http://www.#.com/slir/w280/imagelib/" . $image_row->id . "_" . $image_row->filename;

                echo '<div class="large-featured-image-container"><img src="'.$image_url.'">/div>'; 
            }   

    echo '      <div>';
    echo '        <h2><a href="item-news.php?id='.$row->id.'">'.$row->title.'</a></h2>';
    echo '      </div>';
    echo '    </div>';
    echo '  </div>';
    echo '  <div class="grid_6">';

Any help? Essentially, it needs to apply the second code to the first three items in the query, then follow through with the code included in the current while loop - like an offset I guess.

Thanks, R

Add a counter and use the modulus operator.

Matt Humphrey
– Matt Humphrey

2012-12-12 11:31:34 +00:00
Commented Dec 12, 2012 at 11:31 — Matt Humphrey
– Matt Humphrey, Commented Dec 12, 2012 at 11:31
Use templates to separate the logic and the view!

Bogdan Burym
– Bogdan Burym

2012-12-12 11:35:15 +00:00
Commented Dec 12, 2012 at 11:35 — Bogdan Burym
– Bogdan Burym, Commented Dec 12, 2012 at 11:35

NitayArt · Accepted Answer · 2012-12-12 12:05:44Z

2

This is quite simple. I hope I understood your question correctly:

$i = 0;
while ( ( $row = mysql_fetch_object( $result ) ) !== false ) {
    if ($i < 3) {
        // First code
    } else {
        // Second code
    }
    $i += 1;
}

edited Dec 12, 2012 at 12:05

answered Dec 12, 2012 at 11:37

NitayArt

4564 silver badges6 bronze badges

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

2 Comments

John the Painter Over a year ago

Thanks so much. This makes perfect sense.

NitayArt Over a year ago

Sure, although usually when 'if/else' blocks start to get complicated you should consider using a switch statement instead:

RobMasters · Accepted Answer · 2012-12-12 12:06:43Z

2

Firstly, you should avoid using any mysql_ functions as they are all deprecated and will be removed from future versions of PHP. I'd recommend using PDO instead. See this tutorial to get started.

Then, it'll simply be a case of doing something like this:

foreach($db->query($query) as $index => $row) {
    if ($index < 3) {
        // first 3 items
    } else {
        // other items
    }
}

answered Dec 12, 2012 at 12:06

RobMasters

4,1462 gold badges29 silver badges34 bronze badges

Comments

Sven van Zoelen · Accepted Answer · 2012-12-12 11:35:25Z

0

You can do it easaly with an simple counter and an if statement:

$count = 0;

while(fetching) {
    if($count < 3) {
        // items 1, 2 and 3
    } else {
        // do normal
    }

    $count++;
}

answered Dec 12, 2012 at 11:35

Sven van Zoelen

7,2595 gold badges40 silver badges49 bronze badges

Collectives™ on Stack Overflow

PHP while loop split into two

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related