Strange result 1

[Trusts]

Hi all,

I am trying to list the tables using Show Tables. I don't get a list of tables, I get "id resource #3"

Anyone know about this?

Here is the code:

<?php
$connection=mysql_connect(myIP, myname, mypassword) or die ('unable to connect');
mysql_select_db("mydb", $connection);
$ssql="Show Tables";
$result=mysql_query($ssql,$connection);
echo $result;
mysql_close($connection);
?>


Thanks,
KB

 

[jpadie]

mysql_query returns a resource not a set of text.

try

$result = mysql_query ("show tables");
while ($row = mysql_fetch_assoc($result)){
 echo "<pre>;
 print_r($row);
 echo "</pre>"'
}

 

[Trusts]

thanks, got it to work