Hi,
Got a weird one here - probably just having a brain freeze moment =)
..give 0 results
The Link 58803 has an ExpiryDate of 2008/10/15 00:00:00 - which converts to 1224054000 -- which is LESS than 2147483647.
I always thought if a link wasn't set as a paid listing, the ExpiryDate was set to 2147483647 - so doing:
...should give you the listings that have been paid.
As I said - probably a stupidity moment, but if anyone can help, would be much appreciated =)
TIA
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!
Got a weird one here - probably just having a brain freeze moment =)
Code:
SELECT * FROM glinks_Links WHERE ExpiryDate > 2147483647..give 0 results
Code:
SELECT ExpiryDate FROM glinks_Links WHERE ID = 58803The Link 58803 has an ExpiryDate of 2008/10/15 00:00:00 - which converts to 1224054000 -- which is LESS than 2147483647.
I always thought if a link wasn't set as a paid listing, the ExpiryDate was set to 2147483647 - so doing:
Code:
SELECT * FROM glinks_Links WHERE ExpiryDate > 2147483647...should give you the listings that have been paid.
As I said - probably a stupidity moment, but if anyone can help, would be much appreciated =)
TIA
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!