Jump to content


Photo

Select Date Statement.


  • Please log in to reply
2 replies to this topic

#1 avo

avo
  • Members
  • PipPipPip
  • Advanced Member
  • 148 posts
  • Locationstaffordshire uk

Posted 03 July 2006 - 11:18 AM

hi all

Can you please help me out with this query

im would like to get a date from mysql db if the coloum date is <= todays date within 2 months  but its not working

$sql="Select customer_name from office_1 WHERE date_com <= date_add('".date("Ymd")."', interval 2 month)";

all help appriciated
Im loving it ........

#2 redarrow

redarrow
  • Members
  • PipPipPip
  • Advanced Member
  • 7,308 posts
  • Locationlondon

Posted 03 July 2006 - 11:34 AM

http://www.1keydata....l/sqlandor.html
Wish i new all about php DAM i will have to learn
((EMAIL CODE THAT WORKS))
http://simpleforum.ath.cx/mail2.inc
((PAYPAL INTEGRATION THAT WORKS))
http://simpleforum.a...aypal1_info.inc

#3 avo

avo
  • Members
  • PipPipPip
  • Advanced Member
  • 148 posts
  • Locationstaffordshire uk

Posted 03 July 2006 - 02:03 PM

Hi Thanks

Very interesting page .full of sql examples

Cheers
Im loving it ........




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users