vForums Support Banner


Visit vForums

 

Welcome Guest! Please Login or Register
vForums Support :: Programming & Coding :: Programming Discussion :: Alternation rows in a mysql query - View Topic
Topic Rating: *****
Printable View
Dylan
Junior Member
**

[Avatar]

Posts: 136
Status: Offline
Gender: Male
Joined:  
Reputation: 0%  


pmwwwmsnaimxfire
Alternation rows in a mysql query (2nd Mar 08 at 8:05pm UTC)
Ok I'm looping through some data and displaying each row from the mysql table and displaying it in a table.

My question is I want to alternate between class1 and class2 when looping through the tables.

How would I do that?


Image
Marc
vChat Developer
*****
I <3 Rossy

Posts: 3,388
Status: Offline
Gender: Male
Location: Ontario, Canada
Age: 33
Joined:  

Additional Groups:
Coding Team
***


Reputation: 40%  


pmwww
Re: Alternation rows in a mysql query (2nd Mar 08 at 8:11pm UTC)
Code:
 
  1. $n = 1;
  2. while(mysql_fetch_assoc($query)){
  3.  
  4. //Stuff here
  5. echo '<td class="class' . $n .'">';
  6.  
  7. if($n==1) $n = 2; else $n = 1;
  8. }
 

rroll.to— Shorten a link, rickroll your friends.
Dylan
Junior Member
**

[Avatar]

Posts: 136
Status: Offline
Gender: Male
Joined:  
Reputation: 0%  


pmwwwmsnaimxfire
Re: Alternation rows in a mysql query (2nd Mar 08 at 8:27pm UTC)
Shouldn't it be adding a number to?

EDIT :
Thanks cr0w it works {Smile}


Image
Marc
vChat Developer
*****
I <3 Rossy

Posts: 3,388
Status: Offline
Gender: Male
Location: Ontario, Canada
Age: 33
Joined:  

Additional Groups:
Coding Team
***


Reputation: 40%  


pmwww
Re: Alternation rows in a mysql query (2nd Mar 08 at 8:31pm UTC)
 
Shouldn't it be adding a number to?

EDIT :
Thanks cr0w it works {Smile}


No problem. {Smile}

rroll.to— Shorten a link, rickroll your friends.
 Printable View

All times are GMT+0 :: The current time is 3:30am
Page generated in 0.2027 seconds
This Forum is Powered By vForums (v2.4)
Create a Forum for Free | Find Forums