$result = mysql_query("SELECT Agents FROM Agents") or die(mysql_error()); while($row = mysql_fetch_array( $result )) { $Agent = $row['Agents']; echo "$Agent
"; }