That did it!
Much thanks!!!
Pete
"Michael Rudel" <[EMAIL PROTECTED]> wrote:
>SELECT * FROM asset WHERE hostname ='$hostname' and hostname != '';
>
>Greetinx,
> Mike
>
>Michael Rudel
>- Web-Development, Systemadministration -
>
>Besuchen Sie uns am 20. und 21. August 2001 auf der
>online-marketing-düsseldorf in Halle 1 Stand E 16
>_______________________________________________________________
>
>Suchtreffer AG
>Bleicherstraße 20
>D-78467 Konstanz
>Germany
>fon: +49-(0)7531-89207-17
>fax: +49-(0)7531-89207-13
>e-mail: mailto:[EMAIL PROTECTED]
>internet: http://www.suchtreffer.de
>_______________________________________________________________
>
>
>
>> -----Original Message-----
>> From: Pete K. [mailto:[EMAIL PROTECTED]]
>> Sent: Tuesday, July 24, 2001 4:29 PM
>> To: [EMAIL PROTECTED]
>> Subject: [PHP-WIN] 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/
>
>
>--
>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]
>
>
__________________________________________________________________
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]
