I'm focusing on a task at this time and i'm while using NOW() function to obtain the exact time when customers make a booking, it really works fine on my small local machine but once i submitted it on my small hosting company so when I examined it, it demonstrated another time! I figured maybe it's obtaining the time in the server but how do i change that server time (Should i be right) making it more much like my clock?

Appreciate your time and effort and help.

Use date_default_timezone_set() to create your PHP timezone. And mysql_query("SET time_zone = '...'") to create the MySQL timezone.

However I can't assist you with the extremely inaccurate clock, you will have to request these to repair it.