[SOLVED] Show all data from mysql table

[steviez]

Hi,

 

I have a database table full of banned IP addresses an i want to show them all on one page in a textarea

 

How is this done?

 

Thanks

[revraz]

Use a SQL statement to select them all, use a mysql_fetch statement to put them in a array, echo the array.

[ohdang888]

<?php
mysql_connect("your server name, (most of the time, "localhost")", "username", "password") or die(mysql_error());
mysql_select_db("name of database of ip addresses") or die(mysql_error());

$result = mysql_query("SELECT * FROM name of table ip addressed are stored in ")
or die(mysql_error());  

while($row = mysql_fetch_array($result)){
echo $row[0];
echo '<br>';
}
?>

 

 

[steviez]

thanks