how to ignore the empty fields of a database?

[Phaelle]

In my database, some fields are empty for some recordings.
And I wouldl like that the empty fields don´t appear on the answer page of my search engine or, in other worlds, that I don´t have that kind of things (ie age without anything):
Surname : Sawers
First name : Tom
Age:
Nationality : American
Thanks a million!

[pbmods]

Heya, Raphaelle.

You can check for IS NOT NULL in the WHERE clause of your query:

[code=mysql]SELECT * FROM `theTable` WHERE `Age` IS NOT NULL[/code]

[Phaelle]

In my database, some fields are empty for some recordings.
And I wouldl like that the empty fields don´t appear on the answer page of my search engine or, in other worlds, that I don´t have that kind of things (ie age without anything):
Surname : Sawers
First name : Tom
Age:
Nationality : American

I tried it but I got a result I didn´t expect.
If I put the IS NULL in the WHERE clause, I don´t get the file of Tom Sawers anymore and that´s not what I want.
I would like the file appear like that
Surname : Sawers
First name : Tom
Nationality : American
The Age field doesn´t have to appear in this case because it hasn´t been filled.
Does it exist a way to do that?
thanks again for your help

[code green]

To filter the individual fields out of your recordset becomes a bit complicated.
It is probably tidier to filter them with your php code by checking if the array variable is empty. [PHP]while($record = mysql_fetch_ass oc($result)
{
if(!empty($reco rd['age']))
echo 'age '.$record['age'];
}[/PHP]

[pbmods]

Heya, Raphaelle.

You can instead use [code=mysql]AND `age` <> ''[/code].

[Phaelle]

It works!! thanks a lot for the tip