RE: mysql not valid resource

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Marco,

Have you tried echoing out the sql statement to the browser before it gets
sent to the database? That would show you the exact query string and give
you a chance to see where the error might reside.

$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";

echo $sql //ADD THIS LINE

// COMMENT THIS OUT FOR NOW $query=mysql_query ($sql, $connessione);

Rich
-----Original Message-----
From: Marco Strullato [mailto:marco.strullato@xxxxxxxxx]
Sent: Tuesday, August 09, 2005 9:44 AM
To: php-db@xxxxxxxxxxxxx
Subject:  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=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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux