Different CSS style on last SQL row using PHP

Question

Problem:

To style the last row in a SQL query without using any CSS3 selectors.

PHP code:

while ($item = mysql_fetch_assoc($itemsresult))
{
    $answer = "SELECT IID, Comment FROM betyg_answers WHERE EID = '{$EID}' AND CID = '{$item['CID']}' ORDER BY ID ASC";
    $answerresult = mysql_query($answer) or die ('Error (' . mysql_errno() . ') ' . mysql_error());
    $answer = mysql_fetch_assoc($answerresult);

    if ($answer['IID'] == $item['IID'])
    {
        $html .= '
            <tr>
                <td class="arrow" style="'.$arrow.'"><img src="./img/circle_arrow_right.png" class="arrowimage"></td>
                <td class="numbers" style="'.$numbers.'">'.$itemcounter.'.</td>
                <td class="text" style="'.$text.'">'.$item['Description'].'</td>
            </tr>
        ';
    }
    else
    {
        $html .= '
            <tr>
                <td class="arrow" style="'.$arrow.'">&nbsp;</td>
                <td class="numbers" style="'.$numbers.'">'.$itemcounter.'.</td>
                <td class="text" style="'.$text.'">'.$item['Description'].'</td>
            </tr>
        ';
    }

    $itemcounter++;
}

Last row in SQL query should instead print:

$html .= '
        <tr>
            <td class="arrow" style="'.$lastarrow.'">&nbsp;</td>
            <td class="numbers" style="'.$lastnumbers.'">'.$itemcounter.'.</td>
            <td class="text" style="'.$lasttext.'">'.$item['Description'].'</td>
        </tr>
';

Question:

What needs to be added in the while loop so it recognizes the last row and print a different code instead?

You might want to consider re-writing your SQL to retrieve the answers and items in one query. Also, what if the last row would have matched $answer['IID'] == $item['IID']? — Damien_The_Unbeliever
– Damien_The_Unbeliever, Commented Jun 17, 2012 at 5:43

galymzhan · Accepted Answer · 2012-06-17 05:37:46Z

3

Use a counter:

$i = 0;
$c = mysql_num_rows($itemresult);
while ($item = mysql_fetch_assoc($itemsresult)) {
  $i++;
  if ($i == $c) {
    // This is a last row
  } else {
    // Regular row
  }
}

answered Jun 17, 2012 at 5:37

galymzhan

5,5132 gold badges32 silver badges45 bronze badges

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

Comments

BenMorel · Accepted Answer · 2014-02-01 13:02:17Z

0

there is several ways to do that :

use :last-child ( but this isn't working in IE8)

table tr:last-child { background-color:#ff0000; }
using jQuery method ( this is browser independent)

in document load function, add following jQuery code,

$("td:last-child").css({background-color:"#ff0000"})

edited Feb 1, 2014 at 13:02

BenMorel

37k52 gold badges208 silver badges339 bronze badges

answered Jun 17, 2012 at 5:42

Bhavesh G

3,0285 gold badges47 silver badges69 bronze badges

Collectives™ on Stack Overflow

Different CSS style on last SQL row using PHP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related