hey guys,
A while ago I remembered using SQLYog or some other tool that could
look at two databases (say dev and test versions) and work out the
differences in structure between the two, and generate some SQL to
'upgrade' one to the other (bunch of alter table commands basically).
I'm won
Date: Sun, 5 Mar 2006 16:59:13 +0100
To: mysql@lists.mysql.com
From: Jochen Kaechelin <[EMAIL PROTECTED]>
Subject: is this safe against sql-injection?
Message-Id: <[EMAIL PROTECTED]
Can somebody give me some general hints how to prevent
sql-injection?
You may also want to consider the use of the
Quoting Chris <[EMAIL PROTECTED]>:
SELECT content.name
FROM content as c
INNER JOIN content_categories as cg
ON(c.id = cg.content_id)
INNER JOIN categories as g
ON(cg.category_id = g.id)
WHERE g.id IN (3,5,9)
GROUP BY c.id
HAVING 3 = COUNT(*)
Thanks, Chris - that did the trick alright! I use
q: I want to pull a distinct list of "content" that have a "category"
(we have a content_categories table linking content ids with category
ids), BUT I want it to be able to work from multiple categories in an
AND fashion.
the table structure is, roughly:
content:
id
name
blahblahblah
con
