Timestamp Update with PHP

From: "Timothy J Hitchens" <tim(at)hitcho(dot)com(dot)au>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: Timestamp Update with PHP
Date: 2001-02-16 22:56:10
Message-ID: DGEBJCBBIECKHBIGFEJHAEMKGBAA.tim@hitcho.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

I am having trouble updating a timestamp field inside my database whenever I
use
the normal udpate xyz set x = now() etc etc I get must use case I use cast
and I get a ph error for the =...

ERROR: Unable to identify an operator '=' for types 'bpchar' and 'numeric'
You will have to retype this query using an explicit cast

Does anyone have an example of an update for a timestamp field using php.

I am really trying to use this with PHP and everytime I updated the record
because of a certain state I update the timestamp field.

Thanks..

Timothy Hitchens (Hitcho)
Web Evangelist/Technologist
Voice: +61 7 3396 3500
Fax: +61 7 3396 2633
Cell: +61 419 521 440
SMS: tim(dot)sms(at)hitcho(dot)com(dot)au (subject only)
E-Mail: tim(at)hitcho(dot)com(dot)au
URL: http://www.hitcho.com.au/

-------------------------------------------------

"Everyone is born into this world
with two things freewill and potential
what we do from then on is totally
up to us. Let's all start today and
make a difference in this world."

-------------------------------------------------

Browse pgsql-interfaces by date

  From Date Subject
Next Message Nico 2001-02-17 14:25:09 terminal psql: wrong console keystrokes
Previous Message Peter T Mount 2001-02-16 10:07:12 Re: [INTERFACES] data trnsfer through Web.