Re: [PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread jeffrey_n_Dyke
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

Re: [PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread Terry Riley
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-

Re: [PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread Greg Hetrick
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

Re: [PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread Greg Hetrick
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

RE: [PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread Gary . Every
. 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

Re: [PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread Greg Hetrick
-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

Re: [PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread Kieu D. Trang
://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