NULL as string in WAMP vs LAMP/MAMP

NULL as string in WAMP vs LAMP/MAMP - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: NULL as string in WAMP vs LAMP/MAMP (/showthread.php?tid=7293)

NULL as string in WAMP vs LAMP/MAMP - El Forum - 04-02-2008

[eluser]andjules[/eluser]
Something tells me this hasn't anything to do with CI, but I'm hoping one of you smart folks could help.

I've got a CI app with a search function that returns records from a MySQL database.
In my view, I loop through the rows and output conditionally like this:

Code:
if ($myfield) echo $myfield

works fine on my dev machine (MAMP/OS X) and my shared hosting server (LAMP).

However, I've ported over to a WAMP stack (actually server2go), and now my view is showing NULL everywhere when a field is empty. null values have become strings of "NULL".

I can painfully work around it by rewriting the view to test for "NULL", but does anyone have an idea why it's happening or if there is a config somewhere to control this?

thanks

NULL as string in WAMP vs LAMP/MAMP - El Forum - 04-02-2008

[eluser]andjules[/eluser]
silly me, it was an oddity with a GUI MySQL client's csv export...