$query="SELECT * FROM products"; $result=mysql_query($query); $numrows=mysql_numrows($result); $count=0; while ($count < $numrows) { mysql_result($result,$count,"name"); print("$name"); $i++; }