Thanks to everyone who weighed in on this. It's very much
appreciated. And yes, as Lars figured out, I AM getting a value back
from the DB. Unfortunately, I have no way to control how that date
goes in, but am now looking into how to extract it to match to the PHP
So far and very sadly, none of the SQL solutions posed here work
verbatim, but it gives me a point for research. So far I can't get
the time limitation to pull the username out of the DB. Maybe I'll
wander over to the MYSQL group and ask if I'm doing anything wrong
So far these two queried are doing nothing.
$q = "SELECT username, DATE_FORMAT(banned_until,'%Y-%m-%d')
banned_until FROM banned WHERE username = '$username'";
$q = "SELECT username, banned_until, IF(banned_until > NOW(), 'Y',
'N') AS still_banned FROM banned WHERE username = '$username'";
which is weird. I made sure the username variable is being passed and
that it correctly matches a value in the DB. So it's something else.
But again, thank you for the input all! If you think of anything else
I could do to twea it, I'm all ears!
On May 8, 6:40 am, Captain Paralytic < XXXX@XXXXX.COM > wrote: