From: arrshadowman at msn dot com
Operating system: Windos XP PRO SP3
PHP version: 5.2.11
PHP Bug Type: MySQL related
Bug description: Not Recieving Data From DB
Description:
------------
I'm running a developer setup on my PC. PHP 5.211 and MySQL 5.1 with
Windows IIS. For some reason I can run direct queries on the MySQL Command
Line Client, but using PHP in IE and FireFox, the query does send anything
back. It connects to the database, as the ID counter increments everytime I
load the page, but the table data returns nothing.
Reproduce code:
---------------
---
>From manual page: function.mysql-query#Return Values
---
$con = mysql_connect("localhost","r...@localhost","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("nsc_db", $con);
$result = mysql_query("SELECT * FROM emails", $con);
while ($row = mysql_fetch_array($result));
{
echo
$row['fname']."<BR>".$row['lname']."<BR>".$row['address']."<BR>".$row['age'];
}
Expected result:
----------------
The full list from table 'emails'.
Actual result:
--------------
nothing but the <BR> carriage returns.
--
Edit bug report at http://bugs.php.net/?id=50160&edit=1
--
Try a snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=50160&r=trysnapshot52
Try a snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=50160&r=trysnapshot53
Try a snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=50160&r=trysnapshot60
Fixed in SVN:
http://bugs.php.net/fix.php?id=50160&r=fixed
Fixed in SVN and need be documented:
http://bugs.php.net/fix.php?id=50160&r=needdocs
Fixed in release:
http://bugs.php.net/fix.php?id=50160&r=alreadyfixed
Need backtrace:
http://bugs.php.net/fix.php?id=50160&r=needtrace
Need Reproduce Script:
http://bugs.php.net/fix.php?id=50160&r=needscript
Try newer version:
http://bugs.php.net/fix.php?id=50160&r=oldversion
Not developer issue:
http://bugs.php.net/fix.php?id=50160&r=support
Expected behavior:
http://bugs.php.net/fix.php?id=50160&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=50160&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=50160&r=submittedtwice
register_globals:
http://bugs.php.net/fix.php?id=50160&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=50160&r=php4
Daylight Savings: http://bugs.php.net/fix.php?id=50160&r=dst
IIS Stability:
http://bugs.php.net/fix.php?id=50160&r=isapi
Install GNU Sed:
http://bugs.php.net/fix.php?id=50160&r=gnused
Floating point limitations:
http://bugs.php.net/fix.php?id=50160&r=float
No Zend Extensions:
http://bugs.php.net/fix.php?id=50160&r=nozend
MySQL Configuration Error:
http://bugs.php.net/fix.php?id=50160&r=mysqlcfg
