ID: 29217
Updated by: [EMAIL PROTECTED]
Reported By: all4blitz at fftemple dot it
-Status: Open
+Status: Feedback
Bug Type: Unknown/Other Function
Operating System: Windows 2000 Professional
PHP Version: 4.3.7
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 possible, make the script source available online and provide
an URL to it here. Try avoid embedding huge scripts into the report.
Please provide a small and working test script which
includes
a) a create table statement
b) an insert statement for necessary values in your table
c) the version of mysql server and client
d) provide the name of columns in your select statement,
instead of using SELECT *
Previous Comments:
------------------------------------------------------------------------
[2004-07-16 21:10:04] all4blitz at fftemple dot it
the first part of the code is like this sorry:
$db=mysql_connect($host,$user,$pass);
mysql_select_db("sets", $db);
$query = "SELECT * FROM config LIMIT 0,1";
$settings = mysql_query($query, $db);
while ($sr = mysql_fetch_array($settings)){
if($sr["default"]=="Y"){
------------------------------------------------------------------------
[2004-07-16 21:08:54] all4blitz at fftemple dot it
the first part of the code is like this sorry:
$db=mysql_connect($host,$user,$pass);
mysql_select_db("sets", $db);
$query = "SELECT * FROM config LIMIT 0,1";
$settings = mysql_query($query, $db);
while ($sr = mysql_fetch_array($settings)){
if($sr["default"]=="Y"){
------------------------------------------------------------------------
[2004-07-16 21:05:16] all4blitz at fftemple dot it
Description:
------------
After any mysql query, php returns this string:
"Notice: Undefined index: user in d:\etc..."
"user" is the name of the mysql called field.
But the page still works perfectly.
Reproduce code:
---------------
$db=mysql_connect($host,$user,$pass);
mysql_select_db("sets", $db);
$query = "SELECT * FROM config LIMIT 0,1";
$result = mysql_query($query, $db);
while ($sr = mysql_fetch_array($settings)){
if($row["default"]=="Y"){
$url_noslash=$row["url_noslash"];
$siteurl=$row["url"];
$librerie_att=$row["librerie"];
$admin_user=$row["user"];
$admin_password=$row["password"];
$session_file=$row["sessionfile"];
$counter_hp=$row["contatore_hp"];
$counter_op=$row["contatore_op"];
$predlang=$row["lingua"];
$defaultpage=$row["homepage"];
$predskin=$row["skin"];
}
Expected result:
----------------
variable "$admin_user" equal to mysql field "user" to use in the
background
Actual result:
--------------
Notice: Undefined index: user in d:\etc... on line 11
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=29217&edit=1
