PHP Alternate row help please

[ozone1]

Hi guys i need a little help to list data in different coloured rows

 

i need to list 1st name in <td class="alt1"> 2nd name in <td class="alt2"> and so on

currently it is listing only in <td class="alt1">

 

here is my code any help really appreciated

 

<?php

 

$result[0] = mysql_query("SELECT * FROM videos ORDER BY viewtoday

DESC LIMIT 10");

 

for($i=0;$i<count($result);$i++) {

echo '';

while($row=mysql_fetch_array($result[$i])) {

$id = $row['id'];

$cat = $row['cat'];

$title = $row['title'];

$numviews = $row['viewtoday'];

 

$max_length = 25;

$title = ( strlen($title) > $max_length ?

substr($title,0,$max_length)."..." : $title );

 

 

echo '<table class="listOfShows listOfShowsFirst"><tr>

<td class="alt1">

<a href="videos.php?id=' . $id . '">'. $title . '</a> </td>

</tr>';

 

}

 

}

 

?>

</table></td></table>/php]

 

[.josh]

 

 
$class = ($c % 2 == 0) ? "alt1" : "alt2";
$c++;
echo '<table class="listOfShows listOfShowsFirst"><tr>
<td class="'.$class.'">
            <a href="videos.php?id=' . $id . '">'. $title . '</a>   </td>
      </tr>';

 

 

[ozone1]

thank a lot for the help it worked sorry to bother again how to i add number next to my results like below

 

1. name 1

2. name 2

3.

4.

so on......

 

 

[PHPTOM]

Your $i variable should give the number of the row

 

  Quote

thank a lot for the help it worked sorry to bother again how to i add number next to my results like below

 

1. name 1

2. name 2

3.

4.

so on......

 

 

[.josh]

though you'd probably want to use $i+1 because $i starts at 0 not 1.