ID: 42554
Updated by: [EMAIL PROTECTED]
Reported By: sufinoon at gmail dot com
-Status: Open
+Status: Feedback
Bug Type: MySQLi related
Operating System: windows xp + linux
PHP Version: 5.2.4
New Comment:
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.
Previous Comments:
------------------------------------------------------------------------
[2007-09-04 22:30:45] sufinoon at gmail dot com
Description:
------------
problem:
trying to execute a query
description:
somewhere in the script i try to execute a simple select query like
select * from users;
and i got an empty result although the table contain data
and the i have a database link.
I've tried a bug fix like:
/**
* *fix without it the query fails
*/
mysqli_close ( $db->link_id );
$link_id = mysqli_connect($db_host, $db_username, $db_password,
$db_name, $db_prefix, $p_connect);
It's works only for one query and after that i need to use the fix
again
if this bug is reported , although i couldn't find it, please post the
bug id # for reference
Reproduce code:
---------------
$result = mysqli_query($link_id, 'SELECT g_id FROM groups');
Expected result:
----------------
to have some rows (i know i have them cause i check it in command
client)
Actual result:
--------------
rows = 0
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=42554&edit=1
