[eluser]John_Betong[/eluser]
[quote author="joeizang" date="1256703832"]sorry guys,
on a different note. can you explain how i can use the now() function of mysql in active record when I am inserting a row into my database? I have not been too successful with this at all. this is so I can display the date on a homepage for example like with new articles for instance.
Thanks[/quote]
When I first started using MySQL I struggled with the multitude of functions and relationships available for time, dates and different timeZones. I discovered MySQL's CURRENT_TIMESTAMP and it solved all my problems
Check it out.
No doubt I will stand corrected but I get the distinct impression that MySQL and PHP are far more helpful towards fields set as TIMESTAMP rather than DATETIME.