duplicate entries

Maybe someone can help. this script catches all duplicate entries, in the hostname field of my database. The problem is, if the hostname field is left blank, [not all devices have a DNS name], the script sees the blank field, and thinks it's a duplicate. How can I reword it, so it prevents typed hostnames [like it does now] but allows blank hostnames. Thanks in advance! Pete /*Chck for another item with the same hostname */ $result = mysql_query ("SELECT * FROM asset WHERE hostname ='$hostname' "); // check if row is returned, if yes error, if no insert if (mysql_num_rows($result) != 0) { echo "I'm sorry, I can't do that. A duplicate hostname was found."; } else { // DO INSERT -- _______________________________________ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology & Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/