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!

Don't you need something in your WHERE clause joining these two tables: lsql_CatLinks,lsql_Links ?

~Charlie

AND lsql_Links.ID=lsql_CatLinks.LinkID for the join?



Thanks
HyTC
==================================
Mail Me If Contacting Privately Is That Necessary.
==================================

I don't have Links SQL so I'm not sure on the table/column names. But as long as that is the relation, it should fix the query.

~Charlie

I think he'd also need to remove the single quotes around the table/column name.