I am currently building a php-oracle application for the college I work for, and as part of that application I have cause to to create some insert/update procedures. My best solution for this is to have an input/output parameter representing the id of the field that needs to updated. This
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);
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: firstname.lastname@example.org Subject: [PHP-DB] mysql not valid
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= .
A thought - if he's getting the 'not a valid resource' from just the code he posted, then his problem is with the $connessione variable, and not the query itself. Check to make sure the connection is up at all/etc. and *it* is a valid resource. Generally (well, in the simple case - which is
Hi all How does one do buffered queries with pdo? Any param in pdo-query(), pdo-executeQuery() ? Regards holografix -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php