php while loop variable for every third div

Question

Is their a way in a while loop to assign a variable to a class in a div, for every third item in a while loop. I am using the blueprint structure and the third div is at the end and i need to attacht a "last" class name to every third div so 3rd div 6th div 9th div and so on?

/* LOOP THROUGH SHOEDATA TABLE */

$results = mysql_query("SELECT * FROM shoeData");


while($row = mysql_fetch_array($results)){

$name = $row['name'];
$about = $row['about'];
$company = $row['company'];
$buy = $row['buy'];
$tags = $row['tags'];
$id = $row['id'];
$image = $row['image'];


/* ECHO THE SHOEDATA RESULTS */     

    echo "<div class='imageBorder span-8 column'>";
        echo "<div id='imageHeight'>";
        echo "<img  src='thumbs/$image'>";
        echo "</div>";

        echo "<ul>";

            echo "<li>$name</l1>";
            echo "<li>$about</l1>";
            echo "<li>$company</l1>";
            echo "<li><a href='$buy'>BUY</a></l1>";
            echo "<li>$tags</l1>";
        echo "</ul>";
    echo "</div>";


}/*SHOEDATA WHILE LOOP ENDS */

Jordan S. Jones · Accepted Answer · 2009-11-27 03:54:45Z

30

for ($i = 0; $i < $numRecords; $i++)
{
 $className = "";
 if (($i % 3) == 0)
 {
  $className = "last"
 }

 ....
}

The key part here is the ($i % 3) == 0.

EDIT: The following is in response to your comment.

/* LOOP THROUGH SHOEDATA TABLE */

$results = mysql_query("SELECT * FROM shoeData");

$i = 0;
while($row = mysql_fetch_array($results)){
$i++;
$name = $row['name'];
$about = $row['about'];
$company = $row['company'];
$buy = $row['buy'];
$tags = $row['tags'];
$id = $row['id'];
$image = $row['image'];


/* ECHO THE SHOEDATA RESULTS */         
    $additionalClass = ($i % 3) == 0 ? " last" : "";
    echo "<div class='imageBorder span-8 column" . $additionalClass . "'>";
        echo "<div id='imageHeight'>";
        echo "<img  src='thumbs/$image'>";
        echo "</div>";

        echo "<ul>";

                echo "<li>$name</l1>";
                echo "<li>$about</l1>";
                echo "<li>$company</l1>";
                echo "<li><a href='$buy'>BUY</a></l1>";
                echo "<li>$tags</l1>";
        echo "</ul>";
    echo "</div>";


}/*SHOEDATA WHILE LOOP ENDS */

edited Nov 27, 2009 at 3:54

answered Nov 27, 2009 at 3:18

Jordan S. Jones

13.9k5 gold badges47 silver badges50 bronze badges

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

1 Comment

Cool Guy Yo Over a year ago

Hey Im pretty new to this, how would I implement it above, I added my code above

Henry · Accepted Answer · 2022-10-05 11:20:38Z

3

If the intention is to do something every X item use modulo. Modulo is the remainder of the division and becomes zero if the division is exact an integer.

if(!($counter%3)) {
    // this is 3 6 9 etc.
}
$counter++;

Of course you can do it with any number.

edited Oct 5, 2022 at 11:20

answered May 9, 2017 at 18:00

Henry

1,2801 gold badge12 silver badges10 bronze badges

1 Comment

Tgold brain Over a year ago

this right here is super neat... deserves many votes.

tnypxl · Accepted Answer · 2012-05-10 03:45:33Z

2

If you want to do this on the client-side it can be done with CSS3 (add JS for older browsers [DOMAssistant + Selectivizr]).

CSS: div.imageBorder:nth-child(3n) { /* style attributes will be applied to every 3rd div */ }

answered May 10, 2012 at 3:45

tnypxl

513 bronze badges

Comments

Abdelkader Soudani · Accepted Answer · 2011-12-18 15:06:09Z

1

$sql = "SELECT * FROM shoeData";
$results = mysql_query($sql);
while($row = mysql_fetch_array($results)) {

    // whatever code here 

}

It doesn't seem that MySQL is smart enough performing operations while comparing to true value you must specify $sql, $result because it looks like $row = mysql_fetch_array($results) is TRUE so it gets stuck on true loading the first row of data forever.

edited Dec 18, 2011 at 15:06

user142162

answered Feb 26, 2011 at 4:26

Abdelkader Soudani

111 bronze badge

Collectives™ on Stack Overflow

php while loop variable for every third div

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related