Connecting to a MySQL DB

// (1) Open the database connection
 
   $connection = mysql_connect("localhost","fred","shhh");
 
 
 
   // (2) Select the winestore database
 
   mysql_select_db("winestore", $connection);
 
 
 
   // (3) Run the query on the winestore through the connection
 
   $result = mysql_query ("SELECT * FROM
 
                          wine", $connection);
 
 
 
   // (4) While there are still rows in the result set, fetch the current
 
   // row into the array $row
 
   while ($row = mysql_fetch_array($result, MYSQL_NUM))
 
   {
 
     // (5) Print out each element in $row, that is, print the values of
 
     // the attributes
 
      foreach ($row as $attribute)
 
         print "{$attribute} ";
 
 
 
      // Print a carriage return to neaten the output
 
      print "\n";
 
   }