Mmm.. the following code;
$DB->table('SpiderURLS')->update( { AlreadyChecked => "1" }, { URL => "$_" } ) or die $GT::SQL::error;
.. gives me the following error;
Failed to execute query: 'UPDATE lsql_SpiderURLS SET WHERE URL = ?' Reason: You have an error in your SQL syntax near 'WHERE URL = 'http://www.skydivelinks.com/index.php?PHPSESSID=4e823509fd4b27a74e3' at ...
Note the AlreadyChecked = 1 bit seems to be missing :/
Any ideas?
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
$DB->table('SpiderURLS')->update( { AlreadyChecked => "1" }, { URL => "$_" } ) or die $GT::SQL::error;
.. gives me the following error;
Failed to execute query: 'UPDATE lsql_SpiderURLS SET WHERE URL = ?' Reason: You have an error in your SQL syntax near 'WHERE URL = 'http://www.skydivelinks.com/index.php?PHPSESSID=4e823509fd4b27a74e3' at ...
Note the AlreadyChecked = 1 bit seems to be missing :/
Any ideas?
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!