Snippet Library

This little script is a short way to see the contents of a table in a MySql database.

Change the names to reflect your connection to the database and the field names for the table and categories.

username = the name you need to connect to the database.
password = the password fo the database.
database_name = your name for the database.
table = the name of the table in the database.
field1 = the name of the rows (categories) in that table.

none

 <?
mysql_connect ("localhost","use\r\name","password");
mysql_select_db ("database_name");

$sql = "select * from table";
       $result = mysql_query ($sql);

       while ($row = mysql_fetch_array($result))
              {
              $field1= $row["field1"];
              $field2= $row["field2"];

echo "$field1<br>";
echo "$field2<p>";

              }
?>