PHP/MySQL Reserved Word Test Compiled 2007-05-18 incl. PHP 5 & MySQL 5

The use of a "reserved word" as the name of a MySQL database, MySQL table, MySQL column, or PHP variable, may produce unexpected results.

If either a "reserved word" or suspicious a character is found in the currently configured MySQL database, comments will be displayed below using a contrasting font.

If nothing in the above list is highlighted using the contrasting font then you're probably OK.

If a column name appears above using the contrasting font and your version of MySQL supports the backtick character (`column_name`) you might get by OK by backticking that column name in all your scripts.

Regarding MySQL naming conventions, IMHO, limit yourself to using lower case letters and/or the underscore character in the names of all databases, tables, and columns (or else your application may not work as expected on someone else's system configuration). Avoid using hyphens or else the quoted code may break (interpreting the hyphen as a minus sign). Numerals 0-9 are OK as long as they are not the first character in the name of a database, table, or column.