On Wed, Jul 10, 2002 at 10:04:45PM -0800, Jason Soza wrote:
> I have this nice piece of code to take my SQL result and organize it into a
> nice 5 column table:

Nice is in the eye of the beholder...  Here's what I think is nice:

  echo "<table width=\"100%\" border=\"0\" align=\"center\">\n";
  echo " <tr>\n";

  while ($row = mysql_fetch_array($sql, MYSQL_ASSOC)) {
     echo '  <td align="center"><a href="year.asp?year=';
     echo $row['grad_year'] . '">' . $row['grad_year'] . "</a></td>\n";

  echo " </tr>\n";
  echo "</table>\n\n";

If you want to reverse the order, use an ORDER BY clause in your query 


               PHP classes that make web design easier
        SQL Solution  |   Layout Solution   |  Form Solution
    sqlsolution.info  | layoutsolution.info |  formsolution.info
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
 4015 7 Av #4AJ, Brooklyn NY     v: 718-854-0335     f: 718-854-0409

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to