ID: 41910
User updated by: dan at novapulsar dot com
Reported By: dan at novapulsar dot com
-Status: Feedback
+Status: Open
Bug Type: MySQL related
Operating System: centos4.3
PHP Version: 4.4.7
New Comment:
Can log file settings be affecting the way this is working? I've tried
this on multiple servers, and this seems simple enough to work, but yet
it doesn't.
Do you want a link to a phpinfo page on the server this is being run on
and/or a copy of php.ini in a link?
Previous Comments:
------------------------------------------------------------------------
[2007-07-06 15:43:20] [EMAIL PROTECTED]
/local/dev/php/4_4> ./sapi/cli/php /tmp/5.php
Error on page: this.php -> You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near 'from nothing this is broken' at line 1
I don't see any problems here.
------------------------------------------------------------------------
[2007-07-06 15:37:17] dan at novapulsar dot com
Sorry, early in the morning, I meant mysql_query().
------------------------------------------------------------------------
[2007-07-06 15:35:53] [EMAIL PROTECTED]
What is mysql_execute()?
------------------------------------------------------------------------
[2007-07-06 15:30:24] dan at novapulsar dot com
<?php
//connect to valid mysql server
mysql_connect ("localhost", "user", "password") or die
(mysql_error());
mysql_select_db ("mysql") or die (mysql_error());
/* db doesn't really matter because we're trying to raise an error
based on an invalid query */
$strSQL = "select all from nothing this is broken";
$objResult = mysql_execute ($strSQL) or die (fn_Save_Error ('this.php',
mysql_error()));
/*i expect to see the string generated by the save error function,
mysql_error() as a parameter. instead, the 'return' of mysql_error goes
directly to the screen, instead of being passed as a parameter as it is
documented*/
function fn_Save_Error ($x_page_url, $x_error) {
if (strlen($x_page_url) && strlen($x_error)) {
//output if debugging is on
echo ("Error on page: " . $x_page_url . " -> " . $x_error);
//save to db
}
}
?>
------------------------------------------------------------------------
[2007-07-06 09:06:51] [EMAIL PROTECTED]
Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves.
A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external
resources such as databases, etc. If the script requires a
database to demonstrate the issue, please make sure it creates
all necessary tables, stored procedures etc.
Please avoid embedding huge scripts into the report.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/41910
--
Edit this bug report at http://bugs.php.net/?id=41910&edit=1
