Thread: Timestamp Update with PHP

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
usingan 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.sms@hitcho.com.au (subject only)
E-Mail: tim@hitcho.com.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."

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