Select record based on 'change' date - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Select record based on 'change' date

jacko201jacko201 Posts: 1Member
Hi,

I currently have a database containing a table with the following fields:
signid, sign_typ, changedate and time.

The 'changedate' field is the date on which the star sign changes and becomes 'active' until the next 'changedate' in the table. I am trying to search this field by a date the user enters and display the 'sign_typ'.


I am struggling to get this working and any help would be greatly appreciated.

Regards,
Paul

Comments

  • JonathanJonathan Posts: 2,914Member
    : I currently have a database containing a table with the following fields:
    : signid, sign_typ, changedate and time.
    :
    : The 'changedate' field is the date on which the star sign changes and becomes 'active' until the next 'changedate' in the table. I am trying to search this field by a date the user enters and display the 'sign_typ'.
    :
    :
    : I am struggling to get this working and any help would be greatly appreciated.
    :
    You'd probably find this a lot easier if you added a third filed, enddate, which is the date when this sign ends. Then you can write a query with a WHERE clause like:-

    WHERE changedate >= '$theDateYouHave' AND endDate <= '$theDateYouHave'

    Make sure changedate and enddate have a column type of DATE. You need to feed the date in in the format YYYY-MM-DD if I remember correctly.

    Jonathan

    ###
    for(74,117,115,116){$::a.=chr};(($_.='qwertyui')&&
    (tr/yuiqwert/her anot/))for($::b);for($::c){$_.=$^X;
    /(p.{2}l)/;$_=$1}$::b=~/(..)$/;print("$::a$::b $::c hack$1.");

Sign In or Register to comment.