\n"; print "numbercolour\n"; while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { printf ("$row[number]$row[colour]\n"); } /* Free resultset */ mysql_free_result($result); /* Closing connection */ mysql_close($link); print "\n"; mysql_free_result($test); ?>