\n"; echo "\n"; echo "

Records in table: $table

\n"; echo "namesponsorstartdatestopdate"; echo "\n"; /* print the table rows - this is only one of several possible ways you could loop through a result */ $numRows = mysql_num_rows ($resultHandle); $i = 0; while ($i < $numRows) { echo "\n"; $row = mysql_fetch_row ($resultHandle); echo "\n"; echo "$row[0]$row[1]$row[2]$row[3]"; echo "\n"; $i++; } echo "\n"; mysql_close($conn); ?>