mscreashuns — Tue, 17 Jul 2007 16:37:56 +0000

Thanks. That works wonderfully. I wrote something nearly identical to this earlier, and it wasn't working. I probably had a ')' out of place; I've done that so many times.

Thanks again.

Greg K — Tue, 17 Jul 2007 16:11:56 +0000

Try something like this:

<?php
    $dbConn = @mysql_connect($host,$user,$pass);

    if (!$dbConn)
    {
        echo \"Could not Connect to database server with values given\";
        // Other code here...
    }

    if (!@mysql_select_db($database,$dbConn))
    {
        echo \"Could not access database on the server\";
        // Other code here...
    }

    $sql = \"CREATE TEMPORARY TABLE `tmp123456` (id int)\";
    if (!@mysql_query($sql))
    {
        echo \"Did not have permission to create tables\";
        // Other code here
    }
    
    $sql = \"INSERT INTO `tmp123456` VALUES(1)\";
    if (!@mysql_query($sql))
    {
        echo \"Did not have permission to insert data\";
        // Other code here
    }
    
    if ($dbConn) mysql_close($dbConn);
    
    echo \"Database values look good!\";
?>