Re: [PHP] Best way to figure out whether a query returns RESULT or NON-RESULT
Karam Chand wrote: Hello, I have an app where one module is similar to phpMyAdmin (well only .1%) with error_reporting() set to E_ALL. Now a user can execute any query. What is the best way to know whether a query is result or non-result. e.g. . . . Thanks in advance Regards, Karam As it states on http://www.php.net/mysql_query : Only for SELECT,SHOW,EXPLAIN or DESCRIBE statements *mysql_query()* returns a resource identifier or *FALSE* if the query was not executed correctly. For other type of SQL statements, *mysql_query()* returns *TRUE* on success and *FALSE* on error. A non-*FALSE* return value means that the query was legal and could be executed by the server. So , (false !== $result) means the query was sucessful , and if it was successful (true === $result) would mean that no rows were returned. Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Best way to figure out whether a query returns RESULT or NON-RESULT
Hello, mysql_query() returns non-false even if there was an UPDATE statement and the query was successful. But if I put the $result variable in mysql_num_rows() it returns an error, $result in invalid handle. I was asking how to know that where its an UPDATE statement so I dont call mysql_num_rows() at all. The problem is that if I set error_reporting( 0 ), everything works but we are required to have error_reporting ( E_ALL ) Regards, Karam --- Chris [EMAIL PROTECTED] wrote: Karam Chand wrote: Hello, I have an app where one module is similar to phpMyAdmin (well only .1%) with error_reporting() set to E_ALL. Now a user can execute any query. What is the best way to know whether a query is result or non-result. e.g. . . . Thanks in advance Regards, Karam As it states on http://www.php.net/mysql_query : Only for SELECT,SHOW,EXPLAIN or DESCRIBE statements *mysql_query()* returns a resource identifier or *FALSE* if the query was not executed correctly. For other type of SQL statements, *mysql_query()* returns *TRUE* on success and *FALSE* on error. A non-*FALSE* return value means that the query was legal and could be executed by the server. So , (false !== $result) means the query was sucessful , and if it was successful (true === $result) would mean that no rows were returned. Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Best way to figure out whether a query returns RESULT or NON-RESULT
Karam Chand wrote: Hello, mysql_query() returns non-false even if there was an UPDATE statement and the query was successful. But if I put the $result variable in mysql_num_rows() it returns an error, $result in invalid handle. I was asking how to know that where its an UPDATE statement so I dont call mysql_num_rows() at all. I Chris said, if($result === true || $result === false), no rows were returned. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Best way to figure out whether a query returns RESULT or NON-RESULT
Thanks. Never knew there existed (===). Silly me :) Regards, Karam --- Marek Kilimajer [EMAIL PROTECTED] wrote: Karam Chand wrote: Hello, mysql_query() returns non-false even if there was an UPDATE statement and the query was successful. But if I put the $result variable in mysql_num_rows() it returns an error, $result in invalid handle. I was asking how to know that where its an UPDATE statement so I dont call mysql_num_rows() at all. I Chris said, if($result === true || $result === false), no rows were returned. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php ___ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Best way to figure out whether a query returns RESULT or NON-RESULT
Hello, I have an app where one module is similar to phpMyAdmin (well only .1%) with error_reporting() set to E_ALL. Now a user can execute any query. What is the best way to know whether a query is result or non-result. e.g. $result = mysql_query ( $query, $mysql ); if ( !$result ) { HandleError ( mysql_errno(), mysql_error() ); return; } if ( !mysql_num_rows ( $result ) !mysql_num_fields ( $result ) ) { // handle non_result values return; } // handle result values The problem is that if its an Update stmt. php throws up an error that $result in mysql_num_rows() is not a valid handle. Moreover, from the manual - mysql_affected_rows() does not work with SELECT statements; only on statements which modify records. So to use it I have to figure out if its a non-SELECT statement What you PHP gurus suggest the best way to handle such situations? Thanks in advance Regards, Karam ___ Do you Yahoo!? Express yourself with Y! Messenger! Free. Download now. http://messenger.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php