<?php
     #this loop actually return the first result in the set but 
     # subsquent results will recieve a warning.

      mysql_connect("", "web", "web");
      $result = mysql("careers", "select * from table;");
      $num_rows = mysql_numrows($result);

      for ($i = 1; $i < $num_rows; $i++) {
        # new line w/o table name in field
        echo $i . mysql_result($result, $i, "company") . "<bR>";
        # old line w table name in field
        # echo $i . mysql_result($result, $i, "table.company") . "<bR>";
        }

?>