web stats analysis

Archive for January, 2013

Query for change date format in php from mysql

How to change date format in php from mysql

Change date format in mysql


SELECT *, DATE_FORMAT( date, ‘%Y-%m-%d’ ) AS dateformat FROM tbl_demo;

Note :

 tbl_demo is a table name.
date is a field of tbl_demo table.


Create Full Width Posts in WordPress

Blog post full width page

Full width Posts

Make a Full Width Post For Your WordPress Theme

How to create full width posts?

Creating Full Width Page Template for WP Posts

Steps for Creating A Full Width Post Template is following

1. Download and Install the Custom Post Templates plugin.

2. Open “full-page.php” file in your themes directory and copy the contents of the file.

3. Open notepad editor and paste the code there.

4. At the top, replace the “Template Name: Full Width” with “Template Name Posts: Full Width”.

5. Save the file as “template-fullwidth.php” and upload it to your themes directory.

Now you check your add post page . you will find Full width post template drop down box in the sidebar



Question Marks in Title and Excerpt!

Use Gujarati font in wordpress

Question Marks in Title and Excerpt in wordpress


In your root directory open file wp-config.php and commenting following red color line.

/** Database Charset to use in creating database tables. */
// define(‘DB_CHARSET’, ‘utf8′);

/** The Database Collate type. Don’t change this if in doubt. */
// define(‘DB_COLLATE’, ”);


Display posts in Ascending order.

Display posts in ascending order wordpress

How to display posts in ascending order?

Sort Posts in ascending order


In your display posts page change following code

Change this

<?php if (have_posts()) : ?>


query_posts($query_string . ‘&order=ASC’);
if (have_posts()) : ?>