Use var_dump before processing your result. Regards, Samrat Kar FRD, BARC Tel: 022-25597295 Alternate Email: esamrat@xxxxxxxxx -----Original Message----- From: Dan Shirah [mailto:mrsquash2@xxxxxxxxx] Sent: Wednesday, September 23, 2009 5:28 PM To: PHP General Subject: NULLS vs Empty result in PHP Morning! Just a quick question. Say I have a column in my database that could contain NULLS, empty spaces, or an actual value. If I do: $my_query = "SELECT my_column FROM my_database WHERE 1 = 1"; $my_result = ifx_query($my_query, $connect_id); while($row = ifx_fetch_row($my_result)) { $my_column = trim($row['my_column']); if ($my_column != "") { echo "Test"; } } The way PHP assigns the query results to the $my_column variable, wouldn't; if ($my_column != "") not do anything for the rows that contained NULLS or empty spaces? No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.409 / Virus Database: 270.13.112/2388 - Release Date: 09/22/09 17:54:00 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
