PDO connection object createdArray ( [0] => Array ( [bin_num] => 2 [wine] => Chardonnay [producer] => Buena Vista [year] => 2001 [bottles] => 4 [ready] => 2003 ) [1] => Array ( [bin_num] => 3 [wine] => Chardonnay [producer] => Geyeser Peak [year] => 2001 [bottles] => 5 [ready] => 2003 ) [2] => Array ( [bin_num] => 6 [wine] => Chardonnay [producer] => Simi [year] => 2000 [bottles] => 4 [ready] => 2002 ) [3] => Array ( [bin_num] => 12 [wine] => Joh Riesling [producer] => Jekel [year] => 2002 [bottles] => 1 [ready] => 2003 ) [4] => Array ( [bin_num] => 21 [wine] => Fume Blanc [producer] => Ch St. Jean [year] => 2001 [bottles] => 4 [ready] => 2003 ) [5] => Array ( [bin_num] => 22 [wine] => Fume Blanc [producer] => Robt Mondavi [year] => 2000 [bottles] => 2 [ready] => 2002 ) [6] => Array ( [bin_num] => 30 [wine] => Gewurztraminer [producer] => Ch St. Jean [year] => 2002 [bottles] => 3 [ready] => 2003 ) [7] => Array ( [bin_num] => 43 [wine] => Cab Sauvignon [producer] => Windsor [year] => 1995 [bottles] => 12 [ready] => 2004 ) [8] => Array ( [bin_num] => 45 [wine] => Cab Sauvignon [producer] => Geyeser Peak [year] => 1998 [bottles] => 12 [ready] => 2006 ) [9] => Array ( [bin_num] => 48 [wine] => Cab Sauvignon [producer] => Robt Mondavi [year] => 1997 [bottles] => 12 [ready] => 2008 ) [10] => Array ( [bin_num] => 50 [wine] => Pinot Noir [producer] => Gary Farrell [year] => 2000 [bottles] => 3 [ready] => 2003 ) [11] => Array ( [bin_num] => 51 [wine] => Pinot Noir [producer] => Fetzer [year] => 1997 [bottles] => 3 [ready] => 2004 ) [12] => Array ( [bin_num] => 52 [wine] => Pinot Noir [producer] => Dehlinger [year] => 1999 [bottles] => 2 [ready] => 2002 ) [13] => Array ( [bin_num] => 58 [wine] => Merlot [producer] => Clos du Bois [year] => 1998 [bottles] => 9 [ready] => 2004 ) [14] => Array ( [bin_num] => 64 [wine] => Zinfandel [producer] => Cline [year] => 1998 [bottles] => 9 [ready] => 2007 ) [15] => Array ( [bin_num] => 72 [wine] => Zinfandel [producer] => Rafanelli [year] => 1999 [bottles] => 2 [ready] => 2007 ) )
Array ( [0] => bin_num [1] => wine [2] => producer [3] => year [4] => bottles [5] => ready )

Display Data from tnpayne@ip-172-31-84-83 MySQL cellar

bin_numwineproduceryearbottlesready
2ChardonnayBuena Vista200142003
3ChardonnayGeyeser Peak200152003
6ChardonnaySimi200042002
12Joh RieslingJekel200212003
21Fume BlancCh St. Jean200142003
22Fume BlancRobt Mondavi200022002
30GewurztraminerCh St. Jean200232003
43Cab SauvignonWindsor1995122004
45Cab SauvignonGeyeser Peak1998122006
48Cab SauvignonRobt Mondavi1997122008
50Pinot NoirGary Farrell200032003
51Pinot NoirFetzer199732004
52Pinot NoirDehlinger199922002
58MerlotClos du Bois199892004
64ZinfandelCline199892007
72ZinfandelRafanelli199922007
require 'DB.php'; $d = tnpayne@ip-172-31-84-83 MySQL cellar; $q = $d->('SELECT wine, Dno FROM 'wine'); while ($r = $q->fetchRow() ) { print "wine $r[0] bottles $r[1] \n"; }