You use the field name as a property of the object (in the code you posted):
Code: Select all
<?php
//get activatetime
$activatetime = mysql_query("SELECT activatetime FROM seens_dl WHERE user = '$user'");
$checkactivatetime = mysql_fetch_object($activatetime);
//set cutoff date
$cutoffdate = mktime(0,0,0,date("m"),date("d")-3,date("Y"));
if($checkactivatetime->activatetime < $cutoffdate) {
echo "Sorry, this username was activated more than 3 days ago and can not be used to download anymore.";
}
?>
You could also do something like:
Code: Select all
<?php
//get activatetime
$activatetime = mysql_query("SELECT activatetime FROM seens_dl WHERE user = '$user'");
$checkactivatetime = mysql_fetch_row($activatetime);
//set cutoff date
$cutoffdate = mktime(0,0,0,date("m"),date("d")-3,date("Y"));
if($checkactivatetime[0]['activatetime'] < $cutoffdate) {
echo "Sorry, this username was activated more than 3 days ago and can not be used to download anymore.";
}
?>
or
Code: Select all
<?php
//get activatetime
$activatetime = mysql_query("SELECT activatetime FROM seens_dl WHERE user = '$user'");
$checkactivatetime = mysql_fetch_array($activatetime);
//set cutoff date
$cutoffdate = mktime(0,0,0,date("m"),date("d")-3,date("Y"));
if($checkactivatetime['activatetime'] < $cutoffdate) {
echo "Sorry, this username was activated more than 3 days ago and can not be used to download anymore.";
}
?>
Hope that helps.