Code: Select all
SELECT id, url FROM (
SELECT TOP ($x) id, url FROM (
SELECT TOP ($x) id, url FROM $table WHERE (done = 0) ORDER BY id) AS newtbl ORDER BY id DESC) AS newtbl2 ORDER BY idModerator: General Moderators
Code: Select all
SELECT id, url FROM (
SELECT TOP ($x) id, url FROM (
SELECT TOP ($x) id, url FROM $table WHERE (done = 0) ORDER BY id) AS newtbl ORDER BY id DESC) AS newtbl2 ORDER BY idCode: Select all
$q = "SELECT TOP ($x) url FROM $table WHERE (url NOT IN (SELECT TOP (0) url FROM $table AS spider_1 ORDER BY id)) AND (done = '0') ORDER BY id";
$d = "UPDATE $table SET done = 1 WHERE (url IN (SELECT TOP ($x) url FROM $table AS wwwebayfr_1 WHERE (url NOT IN (SELECT TOP (0) url FROM $table AS spider_1 ORDER BY id)) AND (done = '0') ORDER BY id))";