How to change checkbox value on click

This is the code which i usually use while altering checkbox value and saving checkbox values in db. Code is as follows-

<input type="checkbox" checked="checked" onclick="this.value = this.checked ? 1 : 0;" value="1" name="displayad">

Posted in PHP

How to create another table from existing one in mysql

Following is the mysql syntax for creating new table from an existing one with same structure and data. this type of query is quite useful while you want to create a backup like thing of an existing table. Query is as follows- Following is the mysql syntax for creating –

CREATE TABLE new_table
(SELECT * FROM old_table)

Posted in PHP