I'm not sure if I fully understand but let me give it a shot. You have a
form where a user enters a hostname and your script queries to see if the
hostname they typed in is already in the database. If it is, you give them
an error, if not you insert the record. Now, if the hostname form field is
blank, you want to allow that, right?
$result = mysql_query ("SELECT * FROM asset WHERE hostname ='$hostname' AND
hostname!=''");
----- or -----
if ($hostname != '') {
$result = mysql_query ("SELECT * FROM asset WHERE hostname
='$hostname'");
if (mysql_num_rows($result) != 0) {
echo "I'm sorry, I can't do that. A duplicate hostname was found.";
}
}
else {
// DO INSERT
}
"Pete K." <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED] (Pete K....
> 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]
