My favorite MySQL book is MySQL by Dubois, published by New Riders
At 3:44 PM -0600 2/14/02, Dave Rolsky wrote:
>On Thu, 14 Feb 2002, Bryan Tolka wrote:
>
>> if ($ip ne $oldip){
>> $sth = $dbh->prepare("update ipmgt set
>> ip = '$oldip'
>> hw = ,
>> dnsName = ,
>
>Um, you can't just leave it empty!
>
>Use bound values (read the DBI docs for info on placeholders). This is
>much easier anyway. And read the MySQL docs on SQL since you're obviously
>not terribly familiar with SQL (an introductory SQL book wouldn't hurt
>either).
>
>
>-davet
>
>/*==================
>www.urth.org
>we await the New Sun
>==================*/
--
Sean G. Abel
Development Manager
Clotho Advanced Media, Inc.
www.clotho.com