: 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.");