Undefinded Index on Mysql Result under Win98/PWS
| From: | Greg Kopp | Date: | Fri, 23 Feb 2001 17:20:19 +0000 |
| Subject: | Undefinded Index on Mysql Result under Win98/PWS | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-41342@lists.php.net to get a copy of this message | ||
I am using PHP4 + MySQL + PWS + Windows 98.
We are trying to port over a web site to a laptop for remote use.
However, when we execute a SQL query on a DB in which a filed of the record
contains a NULL value, we get an error.
The code is as follows:
$GetQuery = mysql_query ("SELECT * FROM ApplicantsTbl WHERE App_ID = $qq");
$AppResult = mysql_fetch_array ($GetQuery);
$AppDOB = $AppResult[AppDOB];
The query executes just fine, and PARTS of the $AppResult array get
returned. However...
We are experiencing TWO problems:
First, unless we put quote marks around the index so it reads
$AppResult['AppDOB'], we get an undefined constant. This doesn't happen on
our Linux/Apache web server.
Second, if the field AppDOB contains a NULL value, PHP barks that there is
an undefined index. It appears that it won't even create the index.
I would appreciate any help you could be.
Greg