Timestamps...

    Date: 07/26/05 (MySQL Communtiy)    Keywords: database

    Grettings... first time poster to this community, and I'm in dire need of figuring something out.

    Hindsight being 20/20 and all, I've written a lot of code around the "timestamp" table field for entries that people post. I've just started working on the "edit post" function, and I'm finding that if you update *any* column in the table, the timestamp also updates. Is there any way to make it *not* update automatically?

    The only thing I can think of is running a query, pulling the timestamp and slapping it into a variable, and writing back to the database. I'd rather just have it not auto-update at all, but I'm open to suggestions!

    Thanks!

    Source: http://www.livejournal.com/community/mysql/64381.html

« Frustration.... || Question »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home