TalkPHP - View Single Post

DizzyD · 06-10-2009, 07:38 PM

Well I knew it wouldn't be long. I'm getting "supplied argument is not a valid MySQL result resource" errors and i'm assuming it is because of the sql statement. Is it a caps lock issue or something? I have no idea..

Here's what i'm working with:

Code:

$sql = "SELECT * FROM credits_temp WHERE DATESUB(CURDATE(),INTERVAL 8 HOURS)>=time";
$query = mysql_query($sql);

while ($row = mysql_fetch_array($query)) {

echo $row['time'];
echo "<br />";

}

06-10-2009, 07:38 PM	#12 (permalink)
DizzyD The Wanderer Join Date: Feb 2009 Posts: 11 Thanks: 1	Well I knew it wouldn't be long. I'm getting "supplied argument is not a valid MySQL result resource" errors and i'm assuming it is because of the sql statement. Is it a caps lock issue or something? I have no idea.. Here's what i'm working with: Code: $sql = "SELECT * FROM credits_temp WHERE DATESUB(CURDATE(),INTERVAL 8 HOURS)>=time"; $query = mysql_query($sql); while ($row = mysql_fetch_array($query)) { echo $row['time']; echo "<br />"; }