Saturday, January 15, 2011

get number of records count in mysql

SELECT COUNT('fieldname') AS numcount FROM tablename;
//Instead of using COUNT(*) it is good i think

AJAX full form

Asynchronous JavaScript and XML

find the current date using MySQL

SELECT now();
or
SELECT CURDATE();
or
SELECT CURRENT_DATE();

submit a form without submit button

document.formname.submit(); //It will work when we are using single form in a page

document.forms['formname'].submit(); //It will work when we are using multiple forms

// above formname is our formname

submit a form using javascript

document.formname.submit(); //It will work when we are using single form in a page

document.forms['formname'].submit(); //It will work when we are using multiple forms

// above formname is our formname

maximum length of a database name, table name, field name in MySQL

Database name: 64 characters
Table name: 64 characters
Column name: 64 characters