Re: connection mySQL

Thanks a million for the information and help, Regards, Iccsi, "Jim Giner" wrote in message news:33.34.46741.04F4D635@pb1.pair.com... On 5/9/2014 5:37 PM, iccsi wrote:

I have following code to connect MySQL server. I got Connected to database message, but I got Could not run query : No database selected error message when run mysql_query. I check that the database name is correct, I use root account which should have the rights to do select. I can access my db using phpMyAdmin, so my PHP and MySQL server both running. It seems that it connected to MySQL, but for some reason it does not connect to the database. Are there any configuration need to check for the connection? Your help and information is great appreciated, $hostname = "localhost"; $username = "MyUser"; $password = "mypassword"; try { $dbh = new PDO("mysql:host=localhost;dbname=mydb;charset=utf8", $username, $password);

       echo "Connected to database";
     }

catch(PDOException $e)

    {
    echo $e->getMessage();
     }

$result = mysql_query("SELECT invid, invdate, note, amount FROM invheader"); if (!$result) {

    echo 'Could not run query: ' . mysql_error();
    exit;

} You make a PDO connection but then you are trying to use mysql_* functions to access it - for which you DON'T have a connection. IMHO - stick with pdo as in

$q = "select invid, invdate, note, amount from invheader"; $result = $dbh->query($q); if (!$result) { echo "Could not run query - error msg is: "; $pdo_errinfo = $dbh->ErrorInfo(); echo $pdo_errinfo[2]; exit(); }