$query = mysql_query("SELECT * FROM table "); while ($row = mysql_fetch_array($query)) { $name=$row['name']; echo" $name"; }