RE: [PHP-DB] mysql not valid resource
| From: | Bastien Koert | Date: | Tue, 09 Aug 2005 13:46:05 +0000 |
| Subject: | RE: [PHP-DB] mysql not valid resource | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-40043@lists.php.net to get a copy of this message | ||
try adding some debug code to the statement execution
$query=mysql_query ($sql, $connessione) or die ("error is " .mysql_error());
to get an error message that can help debug the query
bastien
From: Marco Strullato <marco.strullato@gmail.com> To: php-db@lists.php.net Subject: [PHP-DB] mysql not valid resource Date: Tue, 9 Aug 2005 15:43:38 +0200 Hi all, I have a problem with mysql: this code produce a not valid mysq resource. $sql="select distinct des_riga, count ( des_riga ) as freq from k_riga where id_tabella=" . $id_tabella . " and id_colonna=" . $id_colonna . " group by des_riga order by des_riga"; $query=mysql_query ($sql, $connessione); $id_tabella, $id_colonna and $connessione has the correct value... The same query runs perfectly if I exec it directly on the db. Do you have any suggestions? Marco -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php