Saturday, April 1st, 2006
I came across two very nice, easy and simple to install and manage Forum scripts based for PHP/MySQL:
Vanilla
PunBB
Here is a nice example of customizing PunBB at the Mint forums:
http://www.haveamint.com/forum/
Web, Software, Freebies, MySQL |
Wednesday, February 22nd, 2006
Here is a way to import a SQL file that contains statements into MySQL:
mysql –user=youruser –password=yourpassword –database=yourdbname < yourscript.scr
This is excellent when you have let’s say 100,000 records, and you want to import them as INSERT statements, but the SQL file is like 20MB’s! All you need to do is:
1) Optional: Compress your SQL […]
MySQL |
Tuesday, January 17th, 2006
Found a great article at DevShed on “Date Arithmetic With MySQL“. The last few days we’ve been kind of puzzled about how to store and actually utilize dates, throwing them back and forth from PHP to MySQL. There seems to be a lack of documentation about MySQL date functions, I bet alot of people are […]
Web, PHP, Database, MySQL |
Friday, January 13th, 2006
Need a database full with zip codes/cities/area codes/population/counties, and much more? Me too. I’ve found a great one, with more information than you’ll ever need. Just $79.95 and you’re set. Download database as CSV/Access/Excel.
Check it out: Zip Code Database List
It took me a few hours to figure out how to import those two big ass […]
Software, Database, MySQL |