Thread: alternating div bg colour for each record in db

Hi All,

i am displaying records from my db and i want all the odd and even records to have different backgrounds

my code is

PHP Code:

$query = mysql_query("SELECT * FROM tbl_prices WHERE prodID = '$prodID' ORDER BY prodPrice ASC")or die(mysql_query());
$rows = mysql_num_rows($query2);
while($row=mysql_fetch_array($query))
{
    $storeID = $row['storeID'];
    $link = $row['prodLink'];
    $storeinfo = mysql_query("SELECT * FROM stores WHERE storeID = '$storeID'")or die(mysql_error());;
    $info = mysql_fetch_array($storeinfo);
    $name = $info['storeName'];
    $name2 = $info['name'];
    $ids = $info['storeID'];
    $logo = $info['logo'];
    $rating = $info['rating'];?>
    <div class='storeindividual1'>            
    <a href="<?php echo htmlspecialchars($link)?>" target="_blank">
    <span class="prices_store1">
    <?php print "<img src='/$logo' alt='$name' title='$name' border='0' width='88' height='31' />";?>
    </span>
        
    <span class="prices_price1">
    <?php 
    if ($row['prodPrice'] == NULL){
    print "-";
    }
    elseif ($row['prodPrice'] == 0){
    print "-";
    }
    elseif ($row['prodPrice'] == 1){
    print "-";
    }
    else{
    print "£".$row['prodPrice']; 
    }?>
    </span>
    
    <span class="prices_delivery1">
    Free
    </span>
    
    <span class="prices_total1">
    <?php echo "£".$row['prodPrice']?>
    </span>

    <span class="prices_percentage1">
    <?php
        #echo "rrp: ".$prodRRP;
        $strippedRRP = trim($prodRRP,"£");
        $saving = number_format($strippedRRP-$row['prodPrice'],2);
        #echo "saving: ".$saving;
        $percentage = ( $saving / $strippedRRP ) * 100;
        $percentage = number_format($percentage,0);
        echo $percentage."%";?>
    </span>

    </a></div><?php  
}

and its the <div class='storeindividual1'> which i want to replace with the relivant bg changes.

my css is

Code:

.storeindividual1{width:933px;float:left;}

can anyone help with this please?
cheers
Luke

Keep a running total of the results. the mod (remainder) operator can be used to detect odds and evens.

Code:

num%2

It will be one for odds, two for evens.

hi mate,

i have added a counter to my loop which increments with each record, and ive tried the mod (remainder) operator like so

Code:

print ($count%2)

which returns 1 for odd and 0 for even which is fine,

so i have modified my code to check the result of the mod like so

Code:

    if($count%2 == 1)
    {?>
        <div class='storeindividual1'><?php
    }
    else
    {?>
        <div class='storeindividual1'><?php
    }?>

but can i add another class to the above like so

Code:

<div class='storeindividual1,redbg'> or
<div class='storeindividual1,yellowbg'>

for example to add background styling to the divs?

cheers mate

ok sorted it mate thanks

There are a couple of ways to do this, either with the method you have above with some slight changes:

Code:

    if($count%2 == 1)
    {?>
        <div class='storeindividual1'><?php
    }
    else
    {?>
        <div class='storeindividual2'><?php
    }?>

You can add multiple CSS elements by doing the following (notice that there is no comma):

Code:

<div class="storeindividual1 redbg"> or
<div class="storeindividual1 yellowbg">

or you can do this with a small jQuery script:

Code:

<script>
$(document).ready(function()
{
  //for each row
  $("div.storeindividual1:even").css("background-color", "#cOffee");
  $("div.storeindividual1:odd").css("background-color", "#efefef");
});
</script>

How did you resolve it in the end?

hi mate,

i solved it like you suggested

Code:

<div class="storeindividual1 redbg"> or[FONT=monospace]
[/FONT]<div class="storeindividual1 yellowbg">

was the easiest way for me
cheers

I find inline-IFs easier to read in this case:

PHP Code:

print '<div class="storeindividual1 ' . (($count%2==0) ? 'red' : 'yellow') . 'bg">';