Jump to content


Photo

age drop down *SOLVED*


  • Please log in to reply
26 replies to this topic

#21 digitalgod

digitalgod
  • Members
  • PipPipPip
  • Advanced Member
  • 374 posts

Posted 01 August 2006 - 06:58 PM

anyone?

#22 ryanlwh

ryanlwh
  • Staff Alumni
  • Advanced Member
  • 511 posts

Posted 01 August 2006 - 07:48 PM

maybe take off that level=2 for now, so we only test the age part.
Please use EDIT * 100...
Please use
or [php] * 1000...

PLEASE READ THE POSTED SOLUTIONS CAREFULLY * 1000000...

#23 digitalgod

digitalgod
  • Members
  • PipPipPip
  • Advanced Member
  • 374 posts

Posted 01 August 2006 - 08:01 PM

well I don't see what that will change, the level is whether the user is a superadmin, admin, user, etc but ok I'll give it a shot

*edit*

still gives me the same result

#24 ryanlwh

ryanlwh
  • Staff Alumni
  • Advanced Member
  • 511 posts

Posted 01 August 2006 - 08:04 PM

can you output the current query so we can see what's wrong with it...
Please use EDIT * 100...
Please use
or [php] * 1000...

PLEASE READ THE POSTED SOLUTIONS CAREFULLY * 1000000...

#25 digitalgod

digitalgod
  • Members
  • PipPipPip
  • Advanced Member
  • 374 posts

Posted 01 August 2006 - 08:08 PM

sure this is what I got when I select between 18 and 22

SELECT * FROM users WHERE date_birth <= (NOW() - INTERVAL 18 YEAR) AND date_birth >= (NOW() - INTERVAL 21 YEAR) AND level='2' ORDER by id DESC

so I'm guessing I should take off the -1 but then we'll back to the same old problem again...


#26 ryanlwh

ryanlwh
  • Staff Alumni
  • Advanced Member
  • 511 posts

Posted 01 August 2006 - 08:09 PM

ahh... should be +1 there, instead of -1 :)
Please use EDIT * 100...
Please use
or [php] * 1000...

PLEASE READ THE POSTED SOLUTIONS CAREFULLY * 1000000...

#27 digitalgod

digitalgod
  • Members
  • PipPipPip
  • Advanced Member
  • 374 posts

Posted 01 August 2006 - 08:16 PM

all that just for 1 sign.... arrg lo the heat is getting to me.

Thanks again ryanlwh works great so far




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users