Jump to content

changing number format with update query


thara

Recommended Posts

I am using this query to count user views for particular page.

This is my query :

    INSERT INTO tutor_page_views ( tutor_id, views) VALUES ( $tutorId, 1)
                  ON DUPLICATE KEY UPDATE views=views+1

This query is working. But when it is updating I need to update views something like this 01,02,03,04....10,11,12 etc..

At the moment, it works like this 1,2,3....10,11,12 etc.

can anybody tell me how can I do this?

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.