In message <[EMAIL PROTECTED]>, Jer <[EMAIL PROTECTED]> writes
>I've got a column in a MySQL table that I want to show up depending on
>the date. If it's before the date in the "release_dt" column, the text
>should show up. If it's after, the column should not be visible.
>
>Here is the code:
>
>$current = date("Y-n-j");
>if($current < $audio["release_dt"])
>{
>print '<p><i><font color="#DF0000">This recording will be released on
>'.$audio["rel_date"].'.</font></i>';
>}
>
>What am I doing wrong?
>
>When it's viewed this way, the text doesn't show up at all. When I
>change the comparison operator to <=, it doesn't show up. When I
>change it to > or >=, the text shows up no matter what the value of
>"release_dt" is.
>
It sounds as though your dates are not in the same format.
What about
$current = date("Y-n-j");
echo "<P>:$current:".$audio["release_dt"].'</P>';
What do you get.
And you do know that you have 2 different variable names, don't you?
> $audio["release_dt"]
>$audio["rel_date"]
--
Pete Clark
http://www.hotcosta.com
http://www.spanishholidaybookings.com
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
