Tag Archives: MySQL

Useful Softwares for Windows 7 That You Should Install

This is just my note because sometimes I forgot what to install in my computer. So here is the list for it. PsPad Google Chrome Firefox RoboForm Yahoo! Messenger Avira Apache PHP MySQL Microsoft Word 2007 Microsoft Excel 2007 Microsoft Outlook Adobe Photoshop Adobe Professional Nero 9 Internet Download Manager DownThemAll! Addon for Firefox Firebug […]

How to Store Date from Select HTML Tag to MySQL

Storing a date from <select> HTML tag to MySQL database is not that easy. I spent three hours to find out how. First time I tried to, I was thinking that my script was not effective. But, after reading some tutorial I found my own way to do it. Here it is. MySQL script Put […]

WordPress “Error establishing a database connection” Checklist

If it is your first time to install WordPress, you can get annoying Error establishing a database connection. There must be some reasons why this annoying error message appears. Here are the checklist that may help you out: Check that your database is correct. When you create a database manually in cPanel. You must be […]

How to Order MySQL Data Ascending and Descending Based on Field

The syntax is easy to remember. SELECT * FROM <table> ORDER BY <field> <ASC/DESC> Example: mysql_query(“SELECT * FROM groceries ORDER BY shopname ASC”) mysql_query(“SELECT * FROM groceries ORDER BY shopaddress DESC”) mysql_query(“SELECT * FROM students ORDER BY department ASC”) If you don’t want to order it ascending or descending just remove ASC or DESC. It […]

How to Install MySQL Server 5 on Ubuntu 10.10

I found the way to install MySQL Server 5 on Ubuntu. Currently I am using Ubuntu 10.10. This how you do it. sudo apt-get install mysql-server If you are running PHP you will also need to install the php module for mysql 5: sudo apt-get install php5-mysql To create a new database, use the mysqladmin […]