Question to list, since I have not had to venture to the mysqli territory just yet, but is it proper to use mysql_error() with mysqli transactions? This may be what your missing Ethan. mysql_error() looks for a mysql_ transactions doesn't it? Or are they interchangeable? Best, Karl DeSaulniers Design Drumm http://designdrumm.com On Apr 1, 2015, at 10:35 PM, Ethan Rosenberg <erosenberg@xxxxxxxxxxxxxxxxxxxx> wrote: >>> > <snip> > > Richard - > > Thanks. > > The problem is in the database connection. > > from MySQL > > mysql> show tables; > +-----------------+ > | Tables_in_Store | > +-----------------+ > | Charges | > | Customers | > | Food | > | Inventory | > | Orders | > | Purchases | > +-----------------+ > > This code works... > > $hostname="localhost"; > $database="Store"; > $username="ethan"; > $password="xxxxx"; > > > $link = mysqli_connect($hostname, $username, $password); > if (!$link) { > die('Connection failed: ' . mysql_error()); > } > else{ > echo "Connection to MySQL server " .$hostname . " successful! > " . PHP_EOL; > } > > $db_selected = mysqli_select_db($link, $database); > if (!$db_selected) { > die ('Can\'t select database: ' . mysql_error()); > } > else { > echo 'Database ' . $database . ' successfully selected!'; > } > > $sql1 = "show tables"; > $result1 = mysqli_query($link, $sql1); > $row1 = mysqli_fetch_array($result1); > echo 'row1<br />'; > print_r($row1); > > BUT > > The output is .... > > Connection to MySQL server localhost successful! Database Store successfully selected! > row1 > Array ( [0] => Charges [Tables_in_Store] => Charges ) > > What am I missing?? > > TIA > > Ethan > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
