Empty fields for every record

[minds_gifts]

Hello,

If i have a table structure like in my attachment, how can i check for empty fields.That is, I want to check for every record in the table if lastname, street, zip, city and pwd are filled.

For example, in the second record that is with id no:2, street and city are empty.Similarly for the next record with id no:3, lastname,zip and pwd are empty.

So, idno:2 and idno:3 are incomplete.
Now, what i would like to do is, if i press a button, i want to send an e-mail to the respective e-mails which are in idno:2 and idno:3 that they need to fill their information again.

Could somebody please tell me how can i do this one?

Thanks in advance

[minds_gifts]

Any ideas pls.
Heres the attachment as an image

[barand]

Your query needs to be something like

$sql = "SELECT name, email FROM tablename
WHERE (street IS NULL)
OR (zip IS NULL) OR (pwd IS NULL) ";

This gives the records with missing data

$message = "Please provide the missing data from your registration form ";

$result = mysql_query($sql);
while (list($name, $email) = mysql_fetch_row($result)) {
     mail($email, "Missing Data", $message);
}

hth

[FrozNic]

I apologize for my late entry, (you sent me a PM a while back). the way that barand described looks like it would work just fine. If you can't figure it out, give me another hollar, i'll get an email if you respond to this thread. - Froz