collaction of data from same table ???

Discussion in 'PHP' started by aleale, Jul 23, 2012.

  1. #1
    I have a table as table1 and it is storing day, month, and year separately (i.e in c1=day, in c2=month and in c3=year). Everything is going fine, but now i want to display results on my page according to day, month and year.

    It means if i want to select feb month and date 1 with year 2012, it must show the relevant data.

    is it possible to get data according to this condition.????
     
    aleale, Jul 23, 2012 IP
  2. programming.russia

    programming.russia Peon

    Messages:
    9
    Likes Received:
    0
    Best Answers:
    1
    Trophy Points:
    0
    #2
    Select * from table1 where c1=1 AND c2=2 AND c3=2012;
     
    programming.russia, Jul 24, 2012 IP