$result = mysql_query("SELECT * FROM users"); for ($counter=0; $row = mysql_fetch_array($result); $counter++) { echo 'name ' . $row['name'] . ' '; if($counter % 10 == 9) echo '<br>'; }