I have a something that works until there are no more matches, it "uses" 10 lines per time and i've got 21 lines in there right now, and after all are "used" up, setting the USED var to 1, I want it to run this:
Code: Select all
if($sql == "" || !$sql)
{
$sql = "UPDATE `$table` SET `quoted` = '0'";$sql = mysql_query($sql) or die('WTF:'.mysql_error()); // CLEARS quoted column, resets ALL to zero, can quot all again, granted if not quoted in last 3 or whatever days set.
echo "YOU FINISHED QUOTING THE ENTIRE LIST, RESETING LIST NOW!!!<br>\n";
}
else
{
echo "SQL = [$sql]<br>\n";
}
It returns:
Resource id #3
when the list is all finished.
how can i fix this so it runs my if statement and clears the quoted column?
I doubt
will work like I want it to, I think I've tried without success....