Retrieve articles from array of category ids

Question

I have an array of category ids and want to retrieve articles from my mysql database with these category ids. What is the best method for this?

score 8 · Answer 1 · answered Jun 07 '10 at 15:23

8

mysql_query('SELECT * FROM articles WHERE category_id IN (\''.implode('\'',array_map('mysql_real_escape_string',$categories)).'\')');

Specify how articles are joined to categories if this is not how your db/table setup.

answered Jun 07 '10 at 15:23

Wrikken

1

mysql_real_escape_string is not needed, 'tis better to use just intval function here. – silent Jun 07 '10 at 15:29
intval would be preferred when talking about integers indeed, OP didn't mention that though (and using uuid's or even chars for categories is not that rare,) so just to be safe... – Wrikken Jun 07 '10 at 15:39

score 2 · Accepted Answer · edited May 23 '17 at 10:33

2

Look here:

for a safe, parameter-based approach and code sample.

edited May 23 '17 at 10:33

Community

answered Jun 07 '10 at 15:29

Tomalak

2 Answers2