1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Starting and stopping a foreach or while loop.

Discussion in 'PHP' started by GeorgeB., Jul 31, 2006.

  1. #1
    OK I have an sql query that selects 8 items from a database.

    $result = mysql_query("select * from mytable WHERE active='yes' ORDER BY something DESC LIMIT 8) or exit(mysql_error());

    Now I would normally just use a while loop and spit them all out in 1 big table

    while ($info = mysql_fetch_array($result)) {

    echo "
    <tr><td>$info['variable1'];</td></tr>
    <tr><td>$info['variable2'];</td></tr>";

    }

    Or use a foreach loop, whichever I'm feeling that day.

    But in this case I want to list 4, then stop, end the table, start a new table, then list the other 4.

    How would you pull that off? I'm reading up on break / continue but I'm not getting it.
    SEMrush
     
    GeorgeB., Jul 31, 2006 IP
    SEMrush
  2. drewbe121212

    drewbe121212 Well-Known Member

    Messages:
    733
    Likes Received:
    20
    Best Answers:
    0
    Trophy Points:
    125
    #2
    Simply do the math, initialize a counter variable and count it on the while loop.
    
    <?
    $counter = 1;
    
    
    while ($row = mysql_fetch_array($query))
    {
        // Table 1
        if ($counter == 1)
            echo "<table>\n" .
                    "  <tr>\n" .
                    "    <td>{$row['value']}</td>\n" .
                    "  </tr>\n";
        elseif ($counter < 4)
        {
            echo "  <tr>\n" .
                   "    <td>{$row['value']}</td>\n" .
                   "  </tr>\n";
        }
        elseif ($counter == 4)
        {
            echo "  <tr>\n" .
                   "    <td>{$row['value']}</td>\n" .
                   "  </tr>\n" .
                   "</table>\n";
                          
        }
        // Table 2
        elseif ($counter == 5)
            echo "<table>\n" .
                    "  <tr>\n" .
                    "    <td>{$row['value']}</td>\n" .
                    "  </tr>\n";
        elseif ($counter < 8)
        {
            echo "  <tr>\n" .
                   "    <td>{$row['value']}</td>\n" .
                   "  </tr>\n";
        }
        elseif ($counter == 8)
        {
            echo "  <tr>\n" .
                    "    <td>{$row['value']}</td>\n" .
                    "  </tr>\n" .
                   "</table>\n";
                          
        }
    
        
        $counter++
    }
    
    ?>
    
    PHP:


    If the actual query doesn't know how many results you are going to get, I would recommend looking into the modulas operator (%)
     
    drewbe121212, Jul 31, 2006 IP
    GeorgeB. likes this.
  3. GeorgeB.

    GeorgeB. Notable Member

    Messages:
    5,696
    Likes Received:
    288
    Best Answers:
    0
    Trophy Points:
    280
    #3
    Thanks for that. I tried it and it's working.

    Anyone else have a simpler solution?
     
    GeorgeB., Aug 7, 2006 IP
  4. TwistMyArm

    TwistMyArm Peon

    Messages:
    931
    Likes Received:
    44
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I would do:

    
    $counter = 1;
    while ($info = mysql_fetch_array($result)) {
        if ( $counter == 1 ) {
            echo '<table>';
        }
    
        echo '<tr><td>' . $info['variable1'] . '</td></tr>';
        echo '<tr><td>' . $info['variable4'] . '</td></tr>';
    
        if ( $counter == 4 ) {
            echo '</table>';
        }
    
        $counter++;
        if ( $counter > 4 ) {
            $counter = 1;
        }
    }
    
    
    Code (markup):
     
    TwistMyArm, Aug 7, 2006 IP
  5. ip076

    ip076 Peon

    Messages:
    79
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #5
    This should work...tested very little

    
    $Counter = 0;		//Initialize Counter
    $RowsPerTable = 4;	//Number of Rows per Table (Max)
    echo "<table border='1'>\n";	//Start Table
    
    while ($info = mysql_fetch_array($result))
    {		
    	if(($Counter % $RowsPerTable == 0) && ($Counter != 0)) echo "</table>\n<table border='1'>\n";
    	echo "<tr><td>{$info['data']}</td></tr>\n";
    	$Counter++;
    }
    echo "</table>\n";	//End Table
    
    PHP:
    This should work no matter how many rows are returned or how many rows you want per table.

    I was having a problem getting an empty table to begin with because 0 % anything is always 0, so, I put a quick fix in there, couldn't think of any other way to do it (I'm having a brainfart). So, if you have anything better, please include it!
     
    ip076, Aug 7, 2006 IP
  6. GeorgeB.

    GeorgeB. Notable Member

    Messages:
    5,696
    Likes Received:
    288
    Best Answers:
    0
    Trophy Points:
    280
    #6
    Thanks guys, really good ideas to work off of here.
     
    GeorgeB., Aug 7, 2006 IP