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

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Ah, found the problem. I manually added the 'Category' field in MySQLMan,so the .def file didn't have the value in it. I did a re-sync on that table,and that has sorted it :)

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates