MySQL Fetch Array doubt

Question

I´m fetching my database for images to create a gallery. Every row appear inside a <li>. My question is, is it possible, that the first <li> have a class (for example, "visible"), and all the other <li> have a class named "hidden". So the first $row would have a different class than the following... Hope I made myself clear! Thanks

Why was this voted down? And would someone please fix the title, so that it's a better representation of the question? — George Marian
– George Marian, Commented Jul 25, 2010 at 16:35

Shubham · Accepted Answer · 2010-07-25 16:27:41Z

2

Well thats easy! Just track the row number, if it is the first row then echo out class="visible" else class='hidden"

answered Jul 25, 2010 at 16:27

Shubham

22.5k18 gold badges71 silver badges91 bronze badges

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

Comments

karim79 · Accepted Answer · 2010-07-25 16:47:53Z

2

It can be done more shortlier like this:

$i = 1;
while ($row = mysql_fetch_assoc($result)) {
    echo '<li class="' . (($i == 1) ? 'visible' : 'hidden') . '">';
    $i++;
}

answered Jul 25, 2010 at 16:47

karim79

343k67 gold badges420 silver badges409 bronze badges

Comments

kander · Accepted Answer · 2010-07-25 16:30:38Z

0

How about something like

$visible = true;

while(...) {

     if($visible) {
         echo "<li class='visible'>";
     else {
         echo "<li class='hidden'>";
     }
     $visible = false; // Every loop sets it to false, which after the first one will make no difference.
}

answered Jul 25, 2010 at 16:30

kander

4,3061 gold badge28 silver badges43 bronze badges

Collectives™ on Stack Overflow

MySQL Fetch Array doubt

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related