Monday, June 13, 2005

mysql, php, javascript coding

Storing Checkbox Data In Your Database
http://www.phpbuilder.com/columns/laflamme20001016.php3

Get previously auto-generated ID in mysql
mysql_insert_id()

date formatting (yyyy-mm-dd -> dd-mm-yyyy)
full list of parameter %W %M %Y etc http://lists.mysql.com/win32/16924
mysql> SELECT DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
-> 'Saturday October 1997'
mysql> SELECT DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
-> '22:23:00'
mysql> SELECT DATE_FORMAT('1997-10-04 22:23:00','%D %y %a %d %m %b %j');
-> '4th 97 Sat 04 10 Oct 277'
mysql> SELECT DATE_FORMAT('1997-10-04 22:23:00','%H %k %I %r %T %S %w');
-> '22 22 10 10:23:00 PM 22:23:00 00 6'
mysql> SELECT DATE_FORMAT('1999-01-01', '%X %V');
-> '1998 52'

time formatting (24HH:Mi -> HH:MM AM/PM)

Online business opportunity

http://www.dollarbuddy.com
Pay usd1 and get bundle of programs, fonts, templates. When people sign up get usd1 for each. Unlimited time. Receive payment via paypal, stormpay, e-gold

http://www.sedo.com
Earn money from your unused domain names!
Sedo's new Domain Parking Program lets you earn money from your domain names without needing to develop your own site. Even better, Sedo's statistics show that domains parked with Sedo are 5 times more likely to be sold!