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

---

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

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.