Re: PHP/mysql equivalent of PEAR's tableInfo()??

On Jul 13, 2009, at 10:03 AM, Govinda wrote:

I have this code:

      $db_billing=mysqli_connect(localhost,metheuser,mypass,billing);
      if (mysqli_connect_error()) { die("Can't connect: " . mysqli_connect_error()); }

mysqli

      //$dbname = 'billing';
      $sql = "SHOW TABLES";

      $result = mysql_query($sql); // line 53

Now mysql, What are you doing?

Yes. 3 lashing. Thanks. I am not likely to neglect again remembering that mysql and mysqli are different and have different syntax. unfortunately I am still in over my head enough to have to ask.. Here is what I have now: $db_billing=mysql_connect(localhost,metheuser,mypass,billing); if (!$db_billing) { die('Could not connect: ' . mysql_error()); } $sql = "SHOW TABLES"; $result = mysql_query($sql); foreach(mysql_fetch_assoc($result) as $k => $v) { //line 62 $ssql = "DESCRIBE ".mysql_real_escape_string($v); $rresult = mysql_query($ssql); echo "<b>".$k."</b>:<br />\n"; echo "<pre>\n"; print_r(mysql_fetch_assoc($rresult)); echo "</pre>\n"; echo "<br />\n"; } giving this error: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/meee/public_html/somedir/test.php on line 62 I read about: -mysql_fetch_assoc -mysql_query -SHOW TABLES but do not see why this should be failing. Why isn't $result a ' valid MySQL result resource'?

Better late then never! :) I played around with your code tonight and got this working on a test server: <?PHP $db_billing = mysql_connect($DBHOST, $DBUSER, $DBPASS) or die("Could not connect: " .mysql_error()); $db_selected = mysql_select_db($DB, $db_billing);

        if(!$db_selected) {
                die("Can't use database: " . mysql_error());
        }

if (!$db_billing) { die('Could not connect: ' . mysql_error()); }

        $sql = "SHOW TABLES";

        $result = mysql_query($sql) or die("query failed: " .mysql_error());
        $resulttest = mysql_fetch_assoc($result);

        foreach($resulttest as $k => $v) { //line 62
        $ssql = "DESCRIBE ".mysql_real_escape_string($v);
        $rresult = mysql_query($ssql);
        echo "<b>".$k."</b>:<br />\n";
        echo "<pre>\n";
        print_r(mysql_fetch_assoc($rresult));
        echo "</pre>\n";
        echo "<br />\n";
        }

?> The only big difference from what you had is that I moved the mysql_fetch_assoc($result); into a separate line rather then running it from the foreach... Let me know if that helps.