Jump to content

help with querying database


k4pil

Recommended Posts

Hi there people.

I have a table called activity in my database as follows;

ID acID time page
1 2 20060307205835 CRM Home
2 2 20060307205838 View customer detail
3 2 20060407205847 Inventory Home Page
4 2 20060407205911 CRM Home
5 2 20060607205916 Inventory Home Page
6 2 20060607212811 View Cases Screen
7 2 20060707212834 Create Case Screen

I want to query this databse from a certain time to a certain time.
I have got the query working;

SELECT * FROM `activity` WHERE time REGEXP '20060307*'

it returns everything starting with that, ignoring the digits after (those represent time so can be ignored).

I want to be able to search from a date e.g 20060307 to 20060707.

Any one have any idea how i can do this??
Link to comment
https://forums.phpfreaks.com/topic/4388-help-with-querying-database/
Share on other sites

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.