ZXDB mysql query (newbie)

[xx3774]

[mention]PeterJ[/mention] good to know - thanks Peter

[kolbeck]

[mention]xx3774[/mention] - you're welcome, let me know if you need anything else. I'll try my best to support, while [mention]Einar Saukas[/mention] is on "vacation"

/Thomas

[xx3774]

Hi [mention]kolbeck[/mention],
your code selects a single title, e.id = 4010, how would I go about showing all titles?.

WHERE e.id = * doesn't seem to work, I'm guessing it's not that simple.

Try this for ads - also check table referencetypes, reviews are type 10 i think

SELECT m.name AS magazine,i.date_year AS issueyear,i.date_month AS issueno,
ref.page AS pageno,reft.text AS magazine_type,f.name AS magazine_text,
m.link_mask
FROM entries e
INNER JOIN magrefs ref
ON ref.entry_id = e.id
INNER JOIN features f
ON ref.feature_id = f.id
INNER JOIN referencetypes reft
ON ref.referencetype_id = reft.id
INNER JOIN issues i
ON ref.issue_id = i.id
INNER JOIN magazines m
ON i.magazine_id = m.id
WHERE e.id = 4010
AND ref.referencetype_id IN ( 1, 2, 3, 15 )

[kolbeck]

[mention]xx3774[/mention] - Just remove the e.id= XXXX (and also the AND)

So the WHERE clause looks like:
WHERE ref.referencetype_id IN ( 1, 2, 3, 15 )

/Thomas

[xx3774]

Wow, thank you [mention]kolbeck[/mention] you're a star!