note 35118 added to ref.mysql

Hi, I have a mysql database from which I make searches using php. I need to print the results in rows with alternating colors. Can anyone help? My script is below, which is similar to the query at the top of this page. <?php $link = mysql_connect("localhost") or die("Could not connect to server : " . mysql_error()); mysql_select_db("judgments") or die("Could not select database"); $query = "SELECT * FROM data WHERE date = '$date' OR court = '$court' OR plaintiff = '$plaintiff' OR defendant = '$defendant' OR number = '$number' ORDER BY '$order' ASC"; $result = mysql_query($query) or die("Query failed : " . mysql_error()); $numrows = mysql_num_rows($result); if ($numrows == 0) { echo ("<script language='javascript'>alert('No matching records were found for: $court $date $plaintiff $defendant $number'); self.location='datasearch.html'</script>"); //Change to the URL of your search page } else $color1 = '#FFFFFF'; $color2 = '#0033CC'; $color3 = '#FFCC00'; print "<table border = 2 bordercolor=$color1 cellpadding=0 cellspacing=0 style=border-collapse: collapse align = center width = 100%>"; print "<td align = center bgcolor = $color2><font color = $color1><b>ID</b></td></font> <td align = center bgcolor = $color2><font color = $color1><b>Date</b></td> <td align = center bgcolor = $color2><font color = $color1><b>Court</b></td> <td align = center bgcolor = $color2><font color = $color1><b>Plaintiff</b></td> <td align = center bgcolor = $color2><font color = $color1><b>Defendant</b></td> <td align = center bgcolor = $color2><font color = $color1><b>Case No.</b></td>"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { print "<tr>"; foreach ($line as $value) { print "<td align = center bgcolor=$color3>$value</td>"; } print "</tr>"; } print "</table>"; mysql_free_result($result); mysql_close($link); ?> I also need someone to show me how I can order the columns in asc/desc order by simply clicking on the upper row (column title). I've tried for the past two weeks but I realised I need help. Will not give up though. Regards & thanks. Simon ---- Manual Page -- http://www.php.net/manual/en/ref.mysql.php Edit Note -- http://master.php.net/manage/user-notes.php?action=edit+35118 Delete Note -- http://master.php.net/manage/user-notes.php?action=delete+35118&report=yes Reject Note -- http://master.php.net/manage/user-notes.php?action=reject+35118&report=yes