Applying a class in a while loop?

7724

Evening all

I have a While loop querying my database, but I’m confused about one thing. I have four records being called out of the database and I want the 2nd and 4th records to have a class attached to them called ml and records 1st and 3 not to.

So here’s my code



 $SQL = "SELECT * from blah desc LIMIT 1,4";     

 $result = mysql_query($SQL) OR die(mysql_error()); 

while ($row = mysql_fetch_assoc($result))  

    {

$ml10 = ($ml10=='' ? 'ml' : '');

echo '
	   <li class='.$ml10.'">

	   </li>
'; 
}

And here’s the line I’m trying to do it on:

$ml10 = ($ml10=='' ? 'ml' : '');

But it does not seem to work. That aligns the 1st and 3rd ones left, but I want the other ones done! Any ideas?

NogDog

Initialize $ml10 to a non-empty value before the loop starts?

7724

Thanks, do You mean:

$SQL = "SELECT * from blah desc LIMIT 1,4";      

$result = mysql_query($SQL) OR die(mysql_error()); 

$ml10 = '';

while ($row = mysql_fetch_assoc($result))   

    { 

$ml10 = ($ml10=='' ? 'ml' : ''); 

echo ' 
       <li class='.$ml10.'"> 
       content dynamically called out here
       </li> 
'; 
}

That still does the same thing, makes the first and third outputted to give a glass of ml10.

Is there an easier way? Maybe so I can make all even values ie 2 and 4 a value of m10 and odds not?

Thanks

NogDog

No, a "non-empty" value:

$ml10 = "ml";
while...

7724

Ha ha! lol!!

If only I understood English ;-) Yes that works now thanks very much

Just out of interest, is this the best way of dealing with odd and even display items using php or is there a better way?

NogDog

It's probably as good as any, and certainly better than explicitly setting style attributes within each tag.