Monthly Archives: June 2011

JavaScript split

The split() method is used to split a string into an array of substrings, based on a character that divides the parts. The character that divides the parts could be many things, ex – a comma, a slash, a pipe

Posted in Javascript

jQuery focus blur events

In this post I will show how this ‘focus’ and ‘blur’ events are useful to us. In the previous post the addClass and removeClass functions triggered on mouseover and mouseout events. In this example let’s see how these functions get

Posted in jQuery

Jquery addClass/removeClass

The both addClass and removeClass functions used to add new class and remove existing class of any html element. You can see the demo of this function below. Syntax: .addClass( [ className ] ) .removeClass( [ className ] ) See

Posted in jQuery

jQuery Tutorial

In this tutorial you will learn how/where to download jQuery library and then how to include it to your files and how to use all its functions. You can download jQuery library from jQuery site. http://code.jquery.com/jquery-1.4.1.js – download this file

Posted in jQuery

MySQL Order By

The way to order your result in MySQL is to use the ORDER BY statement. The ORDER BY keyword is used to sort the result-set by a specified column. You can sort the results by any field in an ascending

Posted in MySQL

MySQL DISTINCT

Assume in a table, some of the columns may contain duplicate values. This is not a problem; however, sometimes you will want to list only the different (distinct) values in a table. DISTINCT helps to eliminate duplicates. If a query

Posted in MySQL

MySQL Delete

The DELETE statement is used to delete records in a table. If you want to delete a record from any MySQL table then you can use SQL command DELETE. Syntax: DELETE FROM table_name WHERE Clause condition If WHERE clause is

Posted in MySQL

MySQL Update

The UPDATE statement is used to update records in a table. There may be a requirement where existing data in a MySQL table need to be modified. You can do so by using SQL UPDATE command. This will modify any

Posted in MySQL

MySQL AND & OR

The AND operator displays a record if both the first condition and the second condition is true. The OR operator displays a record if either the first condition or the second condition is true. Example for AND : Now we

Posted in MySQL

MySQL Where

We have seen MySQL SELECT command to fetch data from MySQL table. We can use a conditional clause called WHERE clause to filter out results. Using WHERE clause we can specify a selection criteria to select required records from a

Posted in MySQL