"; echo " Course Name Level Intake "; while ($row = mysql_fetch_array($result) ) { $row_color = ($row_count % 2) ? $color1 : $color2; // Echo your table row and table data that you want to be looped over and over here. echo " $row[1] $row[4] $row[2]\n"; // Add 1 to the row count $row_count++; } echo " "; ?>