[RESOLVED] Ignore if empty

[stebut05]

Hi all,

I hope you can help, i have a script that enters details into a database table from another table, but i want it to ignore a insert command if a field is empty.

E.g query customer database then if email field is not empty the script should then enter the email address in another table, but if the email field is empty it should ignore inserting email address (as its empty) into another table.

I hope someone can help and thanks in advance

Regards,

Steven

[laserlight]

Sounds simple enough. What have you tried so far, and where exactly is your problem?

[stebut05]

Hi,

$query = "SELECT customer_email_address FROM Customers WHERE customer_id = '$new_customer_id'";
$result = mysql_query($query) or die(mysql_error());
$rows = mysql_fetch_assoc($result);

if (isset($rows['customer_email_address'])) {

insert script

}

This is not working though, any ideas?

[laserlight]

You might consider using [man]empty[/man] instead, or compare with a blank string, or check the string length.

[stebut05]

Thanks,

i have done !empty and works!! Thanks for your help

Regards