Current location: Hot Scripts Forums » Programming Languages » PHP » mysql search monthly report


mysql search monthly report

Reply
  #1 (permalink)  
Old 07-16-05, 05:01 AM
iconsis iconsis is offline
New Member
 
Join Date: Jul 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
mysql search monthly report

hi,

i need help with, how to get search result in particular date to date.( like 01-01-2005 to 30-01-2005.

thanks.
Reply With Quote
  #2 (permalink)  
Old 07-16-05, 03:02 PM
mpdolan mpdolan is offline
Newbie Coder
 
Join Date: Dec 2004
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Have you tried:

SELECT * FROM table_name WHERE date >= begin date AND < end date

???
Reply With Quote
  #3 (permalink)  
Old 07-18-05, 01:13 PM
xtremenw xtremenw is offline
Newbie Coder
 
Join Date: Dec 2004
Location: Tacoma, WA
Posts: 69
Thanks: 0
Thanked 0 Times in 0 Posts
Quote:
Originally Posted by mpdolan
Have you tried:

SELECT * FROM table_name WHERE date >= begin date AND < end date

???
select * from table_name where `date` between `begin` and `end`
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysql Search Output Question doveroh PHP 0 02-15-05 07:39 PM
SEO Expert Available nakulgoyal Job Offers & Assistance 2 08-14-04 12:38 PM
How to create a php mysql site searchable from search engines? Klesti PHP 2 05-16-04 04:09 PM
Declared Functions skipper23 PHP 4 12-17-03 10:06 AM
index page not showing up skipper23 PHP 3 12-15-03 01:10 PM


All times are GMT -5. The time now is 06:56 AM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.