see page php commandsview story

Script to refresh the returned time as the second runs

I wanted to put a live running clock without having to refresh the browser to update the time every time to know the actual time. The script below will return the time but it won't automatically keeping refreshing unless clicking F5 PHP Code: <?php  $currentdate = date("F j, Y,");   $currenttime = date( "h:i:s A");  echo " Current Date: $currentdate<br>         Current Time: $currenttime<p>";       ?>

How does PHP determine the date when using date functions?

I just learned how to display the current date using php but it's 1:30AM (now Sunday morning) and it displays as Saturday still. How does it determine which time zone the user is in?

Update a date-Time field

Hi I have thousands of records in a table in MYSQL and one of the fields is showing the date and time in this format: YYYY-MM-DD HH:MM:SS Is there a way I can change the time to 00:00:00 leaving the date as it is, without have to reimport all these records again? The reason I want this is so I can have a search by date field on a form using coldfusion, its not searching correctly for me when theres a time present Thanks

Date Manipulation in MySQL

Having a scheduled fake emergency call from your friend to your cellphone during a first date has become somewhat of the norm in today’s dating society. However, a more intriguing, and often more productive, type of date manipulation revolves around the DATE data type in MySQL. MySQL supplies dozens of date functions, yet lacks any trace of a DATE_BAILOUT() function.

Launch Date...

Hey guys, So, VS2010 and .NET 4.0 are going to be launched on Monday, the question is, will you be able to purchase the software on that date, or at a later time? I was under the impression that the 'launch' date does not mean you can actually buy a copy of the software, it's just for PR purposes. Thanks.

date() function returning wrong date!

Hi dudes, I am passing the date function a "datetime" value which is pulled from my DB. The date field looks like this: MySQL Code: date_created     2010-04-16 04:45:32 2010-04-16 04:58:18 2010-04-16 06:02:17 And the PHP like this: PHP Code: while($row = mysql_fetch_assoc($resourceID)) {     echo date("D, M, Y", $row['date_created']); } And what I get output on screen is this: Wed, Dec, 1969 As you can see there is no date in my table (shown above) with such an old date, any ideas what going on? many thanks ;)

Date formatting

Hi guys, just having a bit of trouble with formatting a date. I'm inserting a date to mysql with the following query: Code: $sql3="INSERT INTO orderDetails (compName, package, cost, date) VALUES ('$companyName', '$package', '$cost_record', 'date()')"; In my database, this field is type TIMESTAMP. In my database the time added is as follows: 0000-00-00 00:00:00 which is obviously wrong. I need the time to display in this format: yyyymmddhhmmss I've tried to apply formatting but I must be rubbish at it because it either didn't work, or I got parse errors! Pointers in the right direction would be greatly appreciated!!