This is the code i'm using
$ended = "SELECT *
FROM auction_items
WHERE EndDate < '".date("Y-m-d H:i:s")."'
AND processed = 0";
$resended = mysql_query($ended);
print $ended;
if (!$resended) { echo( mysql_error()); }
while ($row = mysql_fetch_array($resended)) {
echo "<br /><br />Username: ".$row['CurrentBidder'];
} // End of " while($row = mysql_fetch_array($res_ended)) "
if i print the query i get
SELECT * FROM auction_items WHERE EndDate < '2007-12-19 11:43:59' AND processed = 0
If i run the query through phpmyadmin i get 2 rows. When ran through the page i get none. What am i doing wrong?