Calling data from database column

I need to call some info from a database column

[AlvinSA]

Hi

I have a database table with column called "date_expire".

I'm looking to code something that says:
<?php if($databasecolumn['date_expire'] > 'x') { Do something } else { Do nothing } ?>

As you can see I'm new to this. Please help.

[rocknbil]

I have a database table with column called "date_expire".

Do it right in your select.

$some_date = '2010-02-01';
$query = "select date_expire > '$some_date'";

or,

$query = "select date_expire > curdate()";

This will return a 1 for true, 0 for false.

$expired_text = Array ('EXPIRED','NOT EXPIRED');

<?php echo $expired_text[$is_expired]; ?>

where $is_expired is the value returned from the query.