Re: [PHP] PHP 4.2.0 on win2k, can't use mysql_fetch_* functions
Did you turn on Display_errors in php.ini? ---John Holmes... - Original Message - From: Austin W. Marshall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 29, 2002 3:52 PM Subject: [PHP] PHP 4.2.0 on win2k, can't use mysql_fetch_* functions Is there something about the php 4.2.0 windows binary (installer version) that renders the mysql_fetch_* functions useless? I installed php 4.2.0 on windows 2000 along with Apache 1.3.24 and MySQL 3.23.49, and in a script i have a simple SELECT statement. The content is in the database, the query executes successfuly, but it's as if mysql_fetch_array and mysql_fetch_row functions don't return anything. I know mysql support is built-in (as indicated on php.net) and working, because i was able to use php to insert data into the database. On that one computer i was able to recreate the problem consistently and in no situation would mysql_fetch array or _row return anything. I haven't had the opportunity to try this on any other win2k boxen, but am not having any problems in Linux or OpenBSD. Is anyone else experiencing any problems? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP 4.2.0 on win2k, can't use mysql_fetch_* functions
1lt John W. Holmes wrote: Did you turn on Display_errors in php.ini? ---John Holmes... Of Course, i think i even had it at the highest alert level. No errors whatsoever, ... or die(mysql_error()) yields nothing either. - Original Message - From: Austin W. Marshall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 29, 2002 3:52 PM Subject: [PHP] PHP 4.2.0 on win2k, can't use mysql_fetch_* functions Is there something about the php 4.2.0 windows binary (installer version) that renders the mysql_fetch_* functions useless? I installed php 4.2.0 on windows 2000 along with Apache 1.3.24 and MySQL 3.23.49, and in a script i have a simple SELECT statement. The content is in the database, the query executes successfuly, but it's as if mysql_fetch_array and mysql_fetch_row functions don't return anything. I know mysql support is built-in (as indicated on php.net) and working, because i was able to use php to insert data into the database. On that one computer i was able to recreate the problem consistently and in no situation would mysql_fetch array or _row return anything. I haven't had the opportunity to try this on any other win2k boxen, but am not having any problems in Linux or OpenBSD. Is anyone else experiencing any problems? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP 4.2.0 on win2k, can't use mysql_fetch_* functions
Do you have some sample code that we could look at? -- Joshua E Minnie/CIO [EMAIL PROTECTED] Phone: 616.276.9690 Fax: 616.342.8750 Nextel: 616.862.2847 Don't work for recognition, but always do work worthy of recognition. 1lt John W. Holmes [EMAIL PROTECTED] wrote in message 01ee01c1efbb$1889ee60$2f7e3393@TB447CCO3">news:01ee01c1efbb$1889ee60$2f7e3393@TB447CCO3... Did you turn on Display_errors in php.ini? ---John Holmes... - Original Message - From: Austin W. Marshall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 29, 2002 3:52 PM Subject: [PHP] PHP 4.2.0 on win2k, can't use mysql_fetch_* functions Is there something about the php 4.2.0 windows binary (installer version) that renders the mysql_fetch_* functions useless? I installed php 4.2.0 on windows 2000 along with Apache 1.3.24 and MySQL 3.23.49, and in a script i have a simple SELECT statement. The content is in the database, the query executes successfuly, but it's as if mysql_fetch_array and mysql_fetch_row functions don't return anything. I know mysql support is built-in (as indicated on php.net) and working, because i was able to use php to insert data into the database. On that one computer i was able to recreate the problem consistently and in no situation would mysql_fetch array or _row return anything. I haven't had the opportunity to try this on any other win2k boxen, but am not having any problems in Linux or OpenBSD. Is anyone else experiencing any problems? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP 4.2.0 on win2k, can't use mysql_fetch_* functions
Austin, I am using 4.2 on a W2K machine at work and have had no problems with the mysql_fetch_* functions. Only thing I had to get used to was the new way to handle globals. Jeff - Original Message - From: Austin W. Marshall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 29, 2002 3:52 PM Subject: [PHP] PHP 4.2.0 on win2k, can't use mysql_fetch_* functions Is there something about the php 4.2.0 windows binary (installer version) that renders the mysql_fetch_* functions useless? I installed php 4.2.0 on windows 2000 along with Apache 1.3.24 and MySQL 3.23.49, and in a script i have a simple SELECT statement. The content is in the database, the query executes successfuly, but it's as if mysql_fetch_array and mysql_fetch_row functions don't return anything. I know mysql support is built-in (as indicated on php.net) and working, because i was able to use php to insert data into the database. On that one computer i was able to recreate the problem consistently and in no situation would mysql_fetch array or _row return anything. I haven't had the opportunity to try this on any other win2k boxen, but am not having any problems in Linux or OpenBSD. Is anyone else experiencing any problems? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP 4.2.0 on win2k, can't use mysql_fetch_* functions
There's a difference between error_reporting and display_errors. Also, are you _really_ sure your query is returning anything? You may _think_ it is, but if mysql_fetch_array doesn't return anything, then it means your result set is empty. 9 times out of 10 this is going to turn out to be something dumb like a variable was empty that you though wasn't... Show us the code. ---John Holmes... - Original Message - From: Austin Marshall [EMAIL PROTECTED] To: 1LT John W. Holmes [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, April 29, 2002 4:34 PM Subject: Re: [PHP] PHP 4.2.0 on win2k, can't use mysql_fetch_* functions 1lt John W. Holmes wrote: Did you turn on Display_errors in php.ini? ---John Holmes... Of Course, i think i even had it at the highest alert level. No errors whatsoever, ... or die(mysql_error()) yields nothing either. - Original Message - From: Austin W. Marshall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 29, 2002 3:52 PM Subject: [PHP] PHP 4.2.0 on win2k, can't use mysql_fetch_* functions Is there something about the php 4.2.0 windows binary (installer version) that renders the mysql_fetch_* functions useless? I installed php 4.2.0 on windows 2000 along with Apache 1.3.24 and MySQL 3.23.49, and in a script i have a simple SELECT statement. The content is in the database, the query executes successfuly, but it's as if mysql_fetch_array and mysql_fetch_row functions don't return anything. I know mysql support is built-in (as indicated on php.net) and working, because i was able to use php to insert data into the database. On that one computer i was able to recreate the problem consistently and in no situation would mysql_fetch array or _row return anything. I haven't had the opportunity to try this on any other win2k boxen, but am not having any problems in Linux or OpenBSD. Is anyone else experiencing any problems? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP 4.2.0 on win2k, can't use mysql_fetch_* functions
1LT John W. Holmes wrote:
There's a difference between error_reporting and display_errors.
Also, are you _really_ sure your query is returning anything? You may
_think_ it is, but if mysql_fetch_array doesn't return anything, then it
means your result set is empty. 9 times out of 10 this is going to turn out
to be something dumb like a variable was empty that you though wasn't...
Show us the code.
---John Holmes...
I can't remember exactly, this was on asomeone elses computer over the
weekend, i don't normally use php in windows, but the fact that it
didn't work, really bothered me.
But it was something along the lines of
?php
mysql_connect(localhost,,); -- yes the grant tables are set up
that way
mysql_select_db(vendor); -- the db with the conent
$query=SELECT code,desc FROM codes;
$result=mysql_query($query);
while($code=mysql_fetch_array($result)) // or
list($code_id,$desc)=mysql_fetch_row($result) but with the same results
{
echo $code[code] $code[desc] br; //print_r($code) doesn't do
anything either
}
?
That's basically all there is to it. I know for a fact that there is
stuff in the codes table, because not only did i manually insert data, i
had another script insert data (to verify that other mysql functions
worked) and issuing the exact same query manuall yields what it's
expected to. I understand your point about the query not returning
anything, but it can't get any simpler than select code,desc from codes,
which will return everything and code and desc are the only fields.
- Original Message -
From: Austin Marshall [EMAIL PROTECTED]
To: 1LT John W. Holmes [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, April 29, 2002 4:34 PM
Subject: Re: [PHP] PHP 4.2.0 on win2k, can't use mysql_fetch_* functions
1lt John W. Holmes wrote:
Did you turn on Display_errors in php.ini?
---John Holmes...
Of Course, i think i even had it at the highest alert level. No errors
whatsoever, ... or die(mysql_error()) yields nothing either.
- Original Message -
From: Austin W. Marshall [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 29, 2002 3:52 PM
Subject: [PHP] PHP 4.2.0 on win2k, can't use mysql_fetch_* functions
Is there something about the php 4.2.0 windows binary (installer
version) that renders the mysql_fetch_* functions useless?
I installed php 4.2.0 on windows 2000 along with Apache 1.3.24 and MySQL
3.23.49, and in a script i have a simple SELECT statement. The content
is in the database, the query executes successfuly, but it's as if
mysql_fetch_array and mysql_fetch_row functions don't return anything.
I know mysql support is built-in (as indicated on php.net) and working,
because i was able to use php to insert data into the database. On that
one computer i was able to recreate the problem consistently and in no
situation would mysql_fetch array or _row return anything.
I haven't had the opportunity to try this on any other win2k boxen, but
am not having any problems in Linux or OpenBSD. Is anyone else
experiencing any problems?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] PHP 4.2.0 on win2k, can't use mysql_fetch_* functions
The only problem I can see is that you have a column named 'desc' which
is a reserved word. It can cause weird results some times, but seems
like it would cause an error
Don't know what to tell you...
---John Holmes...
-Original Message-
From: Austin W. Marshall [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 29, 2002 1:58 PM
To: 1LT John W. Holmes
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] PHP 4.2.0 on win2k, can't use mysql_fetch_*
functions
1LT John W. Holmes wrote:
There's a difference between error_reporting and display_errors.
Also, are you _really_ sure your query is returning anything? You may
_think_ it is, but if mysql_fetch_array doesn't return anything, then
it
means your result set is empty. 9 times out of 10 this is going to
turn
out
to be something dumb like a variable was empty that you though
wasn't...
Show us the code.
---John Holmes...
I can't remember exactly, this was on asomeone elses computer over the
weekend, i don't normally use php in windows, but the fact that it
didn't work, really bothered me.
But it was something along the lines of
?php
mysql_connect(localhost,,); -- yes the grant tables are set up
that way
mysql_select_db(vendor); -- the db with the conent
$query=SELECT code,desc FROM codes;
$result=mysql_query($query);
while($code=mysql_fetch_array($result)) // or
list($code_id,$desc)=mysql_fetch_row($result) but with the same
results
{
echo $code[code] $code[desc] br; //print_r($code) doesn't do
anything either
}
?
That's basically all there is to it. I know for a fact that there is
stuff in the codes table, because not only did i manually insert data,
i
had another script insert data (to verify that other mysql functions
worked) and issuing the exact same query manuall yields what it's
expected to. I understand your point about the query not returning
anything, but it can't get any simpler than select code,desc from
codes,
which will return everything and code and desc are the only fields.
- Original Message -
From: Austin Marshall [EMAIL PROTECTED]
To: 1LT John W. Holmes [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, April 29, 2002 4:34 PM
Subject: Re: [PHP] PHP 4.2.0 on win2k, can't use mysql_fetch_*
functions
1lt John W. Holmes wrote:
Did you turn on Display_errors in php.ini?
---John Holmes...
Of Course, i think i even had it at the highest alert level. No
errors
whatsoever, ... or die(mysql_error()) yields nothing either.
- Original Message -
From: Austin W. Marshall [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 29, 2002 3:52 PM
Subject: [PHP] PHP 4.2.0 on win2k, can't use mysql_fetch_*
functions
Is there something about the php 4.2.0 windows binary (installer
version) that renders the mysql_fetch_* functions useless?
I installed php 4.2.0 on windows 2000 along with Apache 1.3.24 and
MySQL
3.23.49, and in a script i have a simple SELECT statement. The
content
is in the database, the query executes successfuly, but it's as if
mysql_fetch_array and mysql_fetch_row functions don't return
anything.
I know mysql support is built-in (as indicated on php.net) and
working,
because i was able to use php to insert data into the database.
On
that
one computer i was able to recreate the problem consistently and
in no
situation would mysql_fetch array or _row return anything.
I haven't had the opportunity to try this on any other win2k
boxen,
but
am not having any problems in Linux or OpenBSD. Is anyone else
experiencing any problems?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP 4.2.0 on win2k, can't use mysql_fetch_* functions
Actually, i just used desc for the sake of demonstration, the actual
column name was description. At this point i don't care any more, this
was done on a computer for testing purposes and is no longer an issue.
I was just curious to know if this is a known bug or if it's just some
odd anomoly. Must be an anomoly.
John Holmes wrote:
The only problem I can see is that you have a column named 'desc' which
is a reserved word. It can cause weird results some times, but seems
like it would cause an error
Don't know what to tell you...
---John Holmes...
-Original Message-
From: Austin W. Marshall [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 29, 2002 1:58 PM
To: 1LT John W. Holmes
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] PHP 4.2.0 on win2k, can't use mysql_fetch_*
functions
1LT John W. Holmes wrote:
There's a difference between error_reporting and display_errors.
Also, are you _really_ sure your query is returning anything? You may
_think_ it is, but if mysql_fetch_array doesn't return anything, then
it
means your result set is empty. 9 times out of 10 this is going to
turn
out
to be something dumb like a variable was empty that you though
wasn't...
Show us the code.
---John Holmes...
I can't remember exactly, this was on asomeone elses computer over the
weekend, i don't normally use php in windows, but the fact that it
didn't work, really bothered me.
But it was something along the lines of
?php
mysql_connect(localhost,,); -- yes the grant tables are set up
that way
mysql_select_db(vendor); -- the db with the conent
$query=SELECT code,desc FROM codes;
$result=mysql_query($query);
while($code=mysql_fetch_array($result)) // or
list($code_id,$desc)=mysql_fetch_row($result) but with the same
results
{
echo $code[code] $code[desc] br; //print_r($code) doesn't do
anything either
}
?
That's basically all there is to it. I know for a fact that there is
stuff in the codes table, because not only did i manually insert data,
i
had another script insert data (to verify that other mysql functions
worked) and issuing the exact same query manuall yields what it's
expected to. I understand your point about the query not returning
anything, but it can't get any simpler than select code,desc from
codes,
which will return everything and code and desc are the only fields.
- Original Message -
From: Austin Marshall [EMAIL PROTECTED]
To: 1LT John W. Holmes [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, April 29, 2002 4:34 PM
Subject: Re: [PHP] PHP 4.2.0 on win2k, can't use mysql_fetch_*
functions
1lt John W. Holmes wrote:
Did you turn on Display_errors in php.ini?
---John Holmes...
Of Course, i think i even had it at the highest alert level. No
errors
whatsoever, ... or die(mysql_error()) yields nothing either.
- Original Message -
From: Austin W. Marshall [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 29, 2002 3:52 PM
Subject: [PHP] PHP 4.2.0 on win2k, can't use mysql_fetch_*
functions
Is there something about the php 4.2.0 windows binary (installer
version) that renders the mysql_fetch_* functions useless?
I installed php 4.2.0 on windows 2000 along with Apache 1.3.24 and
MySQL
3.23.49, and in a script i have a simple SELECT statement. The
content
is in the database, the query executes successfuly, but it's as if
mysql_fetch_array and mysql_fetch_row functions don't return
anything.
I know mysql support is built-in (as indicated on php.net) and
working,
because i was able to use php to insert data into the database.
On
that
one computer i was able to recreate the problem consistently and
in no
situation would mysql_fetch array or _row return anything.
I haven't had the opportunity to try this on any other win2k
boxen,
but
am not having any problems in Linux or OpenBSD. Is anyone else
experiencing any problems?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
