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/
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
