Hi,
Can anyone tell me why this won't work? :/
SELECT lsql_Links.* FROM lsql_CatLinks,lsql_Links WHERE 'lsql_CatLinks.CategoryID' = "867"
Basically, I need to grab the lsql_Links.LinkID from lsql_CatLinks, and then based on that.. .also grab the values from lsql_Links.ID, based on the values collected.
I could just do it like;
SELECT * FROM lsql_CatLinks WHERE CategoryID = 867;
...push these ID's into an array.
Loop through the array, and grab hashref.
Can anyone give me a pointer? Its got me going round and round in circles at the moment :(
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!
Can anyone tell me why this won't work? :/
SELECT lsql_Links.* FROM lsql_CatLinks,lsql_Links WHERE 'lsql_CatLinks.CategoryID' = "867"
Basically, I need to grab the lsql_Links.LinkID from lsql_CatLinks, and then based on that.. .also grab the values from lsql_Links.ID, based on the values collected.
I could just do it like;
SELECT * FROM lsql_CatLinks WHERE CategoryID = 867;
...push these ID's into an array.
Loop through the array, and grab hashref.
Can anyone give me a pointer? Its got me going round and round in circles at the moment :(
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!