Reply to Re: Test for NULL values in array/sql database?

Your name:

Reply:


Posted by Ewoud Dronkert on 10/05/06 11:19

On 21 Jun 2005 05:59:09 -0700, madsgormlarsen@gmail.com wrote:
> So therefore I need a function that will filter the data, so it
> does not contain columns with only NULL values. [...]
>
> $query = "SELECT * FROM Andersen WHERE column IS NULL";

Rather: $query = "SELECT * FROM Andersen WHERE column IS NOT NULL";
http://dev.mysql.com/doc/mysql/en/working-with-null.html


--
Firefox Web Browser - Rediscover the web - http://getffox.com/
Thunderbird E-mail and Newsgroups - http://gettbird.com/

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация