|
|
|
Read further if you are getting dates far away into the future (2033).
If you want to get a Timestamp (20020231164333 format) from a mysql
database and format it into a readable output, use this command on your
mySQL query,
assuming you have something like
SELECT lastaccesstime FROM user WHERE userid= 'hecky';
change it to
SELECT date_format(lastaccesstime, '%M %e, %Y') FROM user WHERE userid =
'hecky';
this will format the date to a Month, date year.
the % options should be the same as PHP ones, %M = month, %i = minutes, %Y
= year , etc.
As with PHP's date() function you customize the format.
eg
'Year is %Y, and month is %M'
=Year is 2002,and month is February
Hope this helped
|
|
| bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager
Categories : MySQL, PHP, MySQL, Complete Programs, Databases | | | This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server.
Categories : Databases, MySQL, Complete Programs, PHP, Databases | | | Password reminder
Categories : PHP, PHP Classes, Databases, MySQL, Mail | | | Identify and log search engine access (spiders, robots, etc.) to a page.
Categories : HTTP, Environment Variables, PHP, MySQL, Databases | | | A simple script to count and report hits and the last
modification time of an HTML page. Requires MySQL support
(other DBs should work too, except possibly mSQL).
Categories : HTTP, MySQL, PHP, Databases | | | create a grid out of <INPUT TYPE=TEXT> then saving to a database. Uses
a 'multi-dimension array', but not really as the array is just one big array
with the index of "[$i][$j]". Have a look at the code and you'll see what I
mean.
Categories : PHP, MySQL, Arrays, Databases | | | php-gtk mysql querying tool
Categories : PHP-GTK, MySQL, PHP, Databases | | | Simple conversion functions to change MySQL dates to arrays, arrays to MySQL dates.
Categories : PHP, Arrays, Date Time, Databases, MySQL | | | Specify your connection settings and create a link to a MySQL database.
Categories : PHP, PHP Classes, Databases, MySQL, Beginner Guides | | | dynamic table columns
Categories : PHP, HTML and PHP, Arrays, Databases, MySQL | | | mediaCat-GTK v2.0.0 - an mp3/cd/dvd cataloging utility written in php-gtk which interfaces with mysql and ms access (or db supported by PHP's Unified ODBC Functions)
Categories : PHP, MySQL, MS Access, Utilities, Databases | | | Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0
Categories : PHP, Sessions, Databases, MySQL | | | Pull Down Surfing - Surf on Change
Categories : Java Script, MySQL, HTML and PHP, PHP, Databases | | | Online Automatic Class Generator for MySQL Tables
Categories : PHP, PHP Classes, Classes and Objects, Databases, MySQL | | | Cut your MySQL Connections to 1 line of code
Categories : PHP, Beginner Guides, Databases, MySQL | |
|
|
