[RESOLVED] alternate row class when sfter getting info from db

planethax

Well I am not sure how complicated this will be or if even possible.

A much thanx to bpat1434 & weedpacket and johanafm for getting me this far!!

my current code retrieves info from db, assigns a class to the top 12 rows and inserts an image after the first twelve rows.

Now I am wanting (if possible) to alternate row colors
something like
c0 first row in contender
c1 second row in contender
d0 first row in non contender
d1 second row in non contender

Code is as follows

include_once('db_conn.php');
$query = "SELECT * FROM `nascar_standings` ORDER BY `rank` ASC";
$result = mysql_query($query) or die('MySQL Error: '.mysql_error());

$standings = array();
while($row = mysql_fetch_assoc($result))
{
    $standings[$row['rank']] = $row;
}

$standing_text = "";
$i = 0;  

$chase = '<tr><td colspan="12"><img src="chase-bar.gif" alt="Race for the Chase" /></td></tr>';

foreach($standings as $rank=>$standing)
{
    // No ifcheck here. echo the actual rows each time
    $standing_text .= '<tr '.($standing['in_contention'] == 1 ? 'class="contender"' : 'class="noncontender"').'>';
    $standing_text .= '<td>'.$rank.'</td>';

foreach(array('rank_delta', 'driver', 'points', 'behind', 'starts', 'poles',
        'wins', 'top5', 'top10', 'dnf', 'winnings') as     $stat)
{
    $standing_text .= '<td>'.$standing[$stat].'</td>';
}
$standing_text .= '</tr>';

// Also add the image after each twelve rows.
if (++$i == 12)
{
    $standing_text .= $chase;
}
} 

$tpl -> AssignArray(array('standing' => $standing_text));

planethax

I found a jquery files and some instructions
http://roshanbh.com.np/2008/03/different-color-alternate-row-jquery.html
that may do it,
Would it be easier/better that way? (I would rather stick with php if possible)

Thanx

planethax

Is this going to be too difficult?
Should I attempt another way? (like jquery) or is it possible?

Thanx.

planethax

Is what I am wanting to do possible or no?

Any Advice here?

Thanx.

planethax

Anyone have some guidance on this?

johanafm

Just count each row type. If that % 2, then c0, else c1. And same for the other row type. Just like the initial thing with one image per 12 rows instead of just after 12 rows.

planethax

Well I thought I could hack my way through this but everytime I try I break the great code you all have helped me with.

I believe it is because I already have 2 checks and just can not immplement the new ones needed.

   // Also add the image after each twelve rows.
    if (++$i == 12)
    {
        $standing_text .= $chase;
    }

 $standing_text .= '<tr '.($standing['in_contention'] == 1 ? 'class="contender"' : 'class="noncontender"').'>';

I hope someone can guide me here and get this old newb started.

Thanx.

johanafm

//before the loop
$cont_rows = 0;
$noncont_rows = 0;

// change:  $standing_text .= '<tr '.($standing['in_contention'] == 1 ? 'class="contender"' : 'class="noncontender"').'>'; 
if ($standing['in_contention']) {
	++$cont_rows;
	$standing_text .= '<tr '.($cont_rows % 2) ? 'class="contender_even"' : 'class="contender_odd"'.'>'; 
}
else {
	++$noncont_rows;
	$standing_text .= '<tr '.($noncont_rows % 2) ? 'class="noncontender_even"' : 'class="noncontender_odd"'.'>'; 
}

planethax

Well, I wasnt even close to what you have there, and it does make sence to me a bit.
However still not working,
I get
class="contender_even"class="contender_even"class="contender_even" etc
across top of page then my table (with no class')

here is what I have done ( I thought it might have to do with the first line and added
if ($standing['in_contention'] ==1) but did not work either

$standing_text = "";
$i = 0;
$cont_rows = 0;
$noncont_rows = 0; 
$chase = '<tr><td colspan="12"><img src="chase-bar.gif" alt="Race for the Chase" /></td></tr>';

foreach($standings as $rank=>$standing)
{
    // No ifcheck here. echo the actual rows each time
if ($standing['in_contention']) {
    ++$cont_rows;
    $standing_text .= '<tr '.($cont_rows % 2) ? 'class="contender_even"' : 'class="contender_odd"'.'>';
}
else {
    ++$noncont_rows;
    $standing_text .= '<tr '.($noncont_rows % 2) ? 'class="noncontender_even"' : 'class="noncontender_odd"'.'>';
} 
    $standing_text .= '<td>'.$rank.'</td>';

planethax

I figured I better post more of the code just in case

include_once('db_conn.php');
$query = "SELECT * FROM `nascar_standings` ORDER BY `rank` ASC";
$result = mysql_query($query) or die('MySQL Error: '.mysql_error());

$standings = array();
while($row = mysql_fetch_assoc($result))
{
    $standings[$row['rank']] = $row;
}

$standing_text = "";
$i = 0;
$cont_rows = 0;
$noncont_rows = 0; 
$chase = '<tr><td colspan="12"><img src="chase-bar.gif" alt="Race for the Chase" /></td></tr>';

foreach($standings as $rank=>$standing)
{
if ($standing['in_contention']) {
    ++$cont_rows;
    $standing_text .= '<tr '.($cont_rows % 2) ? 'class="contender_even"' : 'class="contender_odd"'.'>';
}
else {
    ++$noncont_rows;
    $standing_text .= '<tr '.($noncont_rows % 2) ? 'class="noncontender_even"' : 'class="noncontender_odd"'.'>';
} 
    $standing_text .= '<td>'.$rank.'</td>';

foreach(array('rank_delta', 'driver', 'points', 'behind', 'starts', 'poles',
        'wins', 'top5', 'top10', 'dnf', 'winnings') as     $stat)
{
    $standing_text .= '<td>'.$standing[$stat].'</td>';
}
$standing_text .= '</tr>';

// Also add the image after first twelve rows.
if (++$i == 12)
{
    $standing_text .= $chase;
}
} 

$tpl -> AssignArray(array('standing' => $standing_text));

johanafm

Ah, it's an issue of operator precedence. Wrap your ?: statements in parentheses

'<tr '.(($cont_rows % 2) ? 'class="contender_even"' : 'class="contender_odd"').'>';

Apart from that, it looks fine to me. Though, you might as well change

    $standing_text .= '<td>'.$rank.'</td>';

foreach(array('rank_delta', 'driver', 'points', 'behind', 'starts', 'poles',
        'wins', 'top5', 'top10', 'dnf', 'winnings') as     $stat)
{
    $standing_text .= '<td>'.$standing[$stat].'</td>';
}

    foreach(array('rank', 'rank_delta', 'driver', 'points', 'behind', 'starts', 'poles',
            'wins', 'top5', 'top10', 'dnf', 'winnings') as     $stat)
    {
        $standing_text .= '<td>'.$standing[$stat].'</td>';
    }

planethax

Thank you very much!!!! It works perfectly!

Now my next step will be to try and be able to sort by clicking column header, however, I think I better let all this digest first before I try lol.