Only this query won't work within PHP 1

[Sleidia]

Hello,

Could someone tell me why

    $sql_query = "
    show tables like 'mod_rates_%'
    ";
    $query_result = mysql_query($sql_query, $_db_connect) or die ($sql_query);

... produces this :

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource ...

The query works via command line but not within PHP!

What's the catch?

Thanks!

 

[jpadie]

this means that $db_connect is not a connection handle. perhaps it is not available inside the function you are using.

try omitting it, or otherwise check its scope.

 

[Sleidia]

Thanks
As usual, you got it right