Thanks for your input Bobby I was using mysql_fetch_array() but changed to mysql_fetch_assoc() The funny thing is, I have a page that does the var_dump() and all I'm doing is refreshing the page and sometimes I get 18 other times 16 variables
Gavin Auckland, New Zealand > -----Original Message----- > From: Bobby Patel [SMTP:[EMAIL PROTECTED] > Sent: Friday, March 21, 2003 11:29 AM > To: [EMAIL PROTECTED] > Subject: [PHP] Re: Missing session vars when doing var_dump() > > I would think that they are 16 key/value pairs when the MySQL (TEXT) > fields > are null thus the session variables are NOT set thus NOT present. > > Hypothsis: I believe that your are using > mysql_fetch_array($query_resource), > try using the second parameter as well ie. > mysql_fetch_array($query_resource, TYPE_OF_ASSOCIATION) example > mysql_fetch_array($query_resource, MYSQL_ASSOC) (please see php.net for > details of "mysql_fetch_array"). > > By using the second parameter, even NULL values will has a variable set. > > Example say you had a field called FirstName in the MySQL database. If it > was NULL, then without the additional parameter you would have NO key > named > 'FirstName' exisiting (ie it is not set). But if you used the second > parameter a key would be created with no value (ie it is set but empty). > > So remember, the second parameter is OPTIONAL, but it has different > behaviors when you do (and do not) use it. Hopefully I cleared it up (or > at > least shed some light). > > checkout : http://www.php.net/manual/en/function.mysql-fetch-array.php > > > "Gavin Jackson" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > Hi > > > > I have come across a strange problem. I have an application that a user > > logs into and when I find the user in the database I load all the custom > > info for that use which I store. By the time I'm done, the session array > > has 18 key's. When I do a var_dump($_SESSION) I sometimes get > > 18 variables and sometimes I only get 16. The two fields that are > missing > > are TEXT fields from a MySQL database and they also appear to be > > the last two keys when var_dump() returns all 18 keys. > > > > Does anyone know what is causing this, it's driving me crazy at the > > moment with many late nights. The PHP version running is 4.2.3 > > > > Regards > > > > Gavin > > > > Auckland, New Zealand > > > > > > -- > 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