[PHP-DB] mysql not valid resource

2005-08-09 Thread Marco Strullato
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);

RE: [PHP-DB] mysql not valid resource

2005-08-09 Thread Bastien Koert
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 [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] mysql not valid

RE: [PHP-DB] mysql not valid resource

2005-08-09 Thread Hutchins, Richard
AM To: php-db@lists.php.net Subject: [PHP-DB] mysql not valid resource 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

Re: [PHP-DB] mysql not valid resource. .

2005-08-09 Thread Martin Norland
: [PHP-DB] mysql not valid resource 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