Time() functionview story

Help me in Event Management

Hi to all, I m created online ticket creating and selling website and i have requirement of selling ticket must close before 30 minutes of event started but i have problem that which timezone i should consider bcoz customer is from any corner of world and may i have hosted my site to any other location so time varies related to timezone for example if i have hosted my site to uk server and event started 8 pm in london and i want to close selling ticket on 7:30pm but i ticket buyer is from China or from other timezone so how can i achieve that buyers from other timezone also come to know that ticket selling is closed!! so plz help in this thanks in advance....

Convert UTC time to a definable local time

There are probably a million threads about time conversion, but I cannot find the answer to my problem. So I'm making it a million and one... I have my date/time stamps stored in UTC (ie number of second since the Unix Epoch). How do I convert this to a definable local time in JavaScript? With definable I mean any local time, not necessarily the machine local time. In PHP I would do it as follows: Code: $utc = time(); // current UTC $timezone = "America/New_York"; date_default_timezone_set($timezone); echo date("Y-m-d H:i:s", $utc); The above would give the current date/time in New York. I would like to be able to do this in JavaScript for any time given in UTC.

why wordpress using two column to store post date

I see wordpress database on wp_posts table, there are 2 columns to store post date, post_date and post_date_gmt post_date_gmt store the post date in GMT time. And post_date store post date in user time who create the post. Am I right? Is there any benefit to store both version of post date on database? Is it faster to store both version of post date rather than calculate post_date_gmt with user timezone when user want to view post date based on his/her timezone

Problems installing SilverStripe

I'm trying to install SilverStripe to my PC and I'm having a problem (I've posted this on their dedicated forum but there's only me and one other person logged on so I might be waiting a while for an answer!) I've installed Apache, PHP5 and MySQL seperately and used them for something else so I know they work. When the script runs to install it, I get this in return: [Warning] strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/London' for '1.0/DST' instead

Populate dropdown menu from MySQL database?

I would like to create a dropdown menu in PHP that loops through a MySQL database table of names. The dropdown will just display the name and the user can select the name for form submission. Each name in the table also has a unique id. Im totally lost on this one... Any help would be great! Thanks

dynamic dropdown menus

OK, firstly am no ASP techie, more of a PHP person myself so I need a bit of help here. I have been asked to create a search function for a website which comprises of the following criteria. I need 3 dropdown menus. The menus will be populated with data from a SQL database. The menus will need to be: Category -> Product Series -> Product. Each dropdown menu will be populated with data depending on the previous menu i.e. the first menu selection populates the second and so on.

Using a dropdown box with AJAX newbie question

Hi there, I want to use a dropdown box on my site, and when a user selects on of the options, I want to display some data from the database. If say they select 'cars' from the dropdown box, I would SELECT cars from the database, if they select Bikes, I would SELECT bikes from the database. Can anyone point me in the right direction with this AJAX? Just wanting to use something nice and simple. Thanks given for any help with this.