Do you have an 'or die(mysql_error())' statement following your
mysql_query($result) line. 99% of the time, this error means your query
failed. if it works on another serverare the fields the same, the
dbname, the tablename?
hth
jeff
As far as I know, that error means that the query that was supposed to
produce $result did not run because of errors in the SQL (or the
database).
Suggest you check your query in myPHPAdmin or MySQLfront or whatever to be
sure that it has no errors.
Terry
--Original Message-
I do not have the die statment -- the DB is the same except the name and I
have double checked that I just did a back up of the previous db and moved
it to the new server. I have done some more digging, my query appears to
work, but I almost appears that I have a problem with selecting the
Query is correct appears to be a problem connecting to the db -- I can
comment out the mysql_select line and I get no change.
Terry Riley [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
As far as I know, that error means that the query that was supposed to
produce $result did not run
. UNIX Administrator
Ingram Entertainment
(615) 287-4876
Pay It Forward
mailto:[EMAIL PROTECTED]
http://accessingram.com
-Original Message-
From: Greg Hetrick [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 12:31 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array
-Original Message-
From: Greg Hetrick [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 12:31 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array issues.
I do not have the die statment -- the DB is the same except
the name and I
have double checked that I
://accessingram.com
-Original Message-
From: Greg Hetrick [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 12:31 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql_fetch_array issues.
I do not have the die statment -- the DB is the same except
the name and I
have