mysql not valid resource
| From: | Marco Strullato | Date: | Tue, 09 Aug 2005 13:43:38 +0000 |
| Subject: | mysql not valid resource | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-40042@lists.php.net to get a copy of this message | ||
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