I've used DATE_ADD function in MySQL for similar purposes:
"SELECT id, DATE_FORMAT(DATE_ADD(datecreated, INTERVAL 2 HOUR), '%c/%e/%y
at: %l:%i %p'), email, name, comments FROM $table_name order by id limit
$offset,10;"
Todd F.
- Original Message -
From: "David Gilden" <[EMAIL PROTECTED
LWP doesnt see a response from Galaxy Embedded Web Server.
I have a cheeep router with an embedded Web server for maintenance.
I'd like to read the stats page with LWP, but LWP doesnt get the body of the
response. It returns the "OK" response, but no body
If I step thru the code, it looks like
"David Gilden" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> One final question here on my SQL -- PERL DBI
>
>
> the following is wrong -- it does not work !
>
> $sql = qq|insert into $table_name values
(null,now(),"$email","$name","$comments");|;
> $sql = $dbh->quote($sql); ## thi
> I am a complete newbie to CGI and have no programming experience. Do
> any of you have a good recommendation on books are resources that will
> help me?
On the command line...
perldoc perldoc
Or if you prefer a browser based tutorial, try perldoc.com
In particular: http://perldoc.com