http://plugins.jquery.com/project/color

hide, show and toggle functions in jQuery have optional callback function (used within the same parentheses), that allows to assign action after the effect is finished. For example, after something is shown or revealed, you may go to a URL or display a pop-up alert box. Here’s an example: <script type=”text/javascript”> $(document).ready(function(){ $(‘:submit’).click(function () { […]

Use the toggle function: $(‘:submit’).click(function () { $(‘div’).toggle(); });

If you hide several elements located one nextto another, you can assign increasingly faster speed to hiding each element, for example like this: <script type=”text/javascript”> $(document).ready(function(){ $(‘:submit’).click(function () { $(‘#veryslowhide’).hide(‘4000’); $(‘#slowhide’).hide(‘3000’); $(‘#fasthide’).hide(‘2000’); $(‘#fasthide’).hide(‘1000’); }); }); </script> <script type=”text/javascript”>$(document).ready(function(){ $(‘:submit’).click(function () {$(‘#slowhide’).hide(‘1000’);$(‘#fasthide’).hide(‘300’);}); });</script>

PHP automates inserting data into MySQL table by using INSERT command within PHP code.

Use asterisk character in the SELECT statement like this: SELECT * FROM name_of_table

SELECT field_name, another_field_name FROM table_name

INSERT INTO table_name (column_name1, column_name2, …) VALUES (‘value1’, ‘value2’, …) Important: there should be no comma after the last element within both sets parentheses; single quotes must be used for any string values; order of columns should correspond to the order of values. 

mysql> CREATE TABLE `name_of_table` ( `first_field_name` varchar (100),  `second_field_name` varchar(100), `and_s0_on` );