How to remove from a table by condition?

Question

PHP

Hello.

// получаю id категорий через запятую из таблицы
$connect = $db->query("SELECT * FROM `o_post` WHERE `id` = '$an_id'");
$get = $db->get_row($connect);

// создаю массив, чтобы работать с ним
$categories = explode(',', $get['category']);

How to loop through the resulting array and display from the table a maximum of 5 records whose post id is equal to the one sent ($an_id) and in the category column there are at least two matches in the array (it should be taken into account that categories are stored in the table separated by commas )?
Cycles are very tight..
Thanks in advance for your help.

Answer 1

category table are stored separated by commas

This is a joke? What for? How to work with it?
there is a LIMIT for this
And what in php is given to you easier than cycles? Just wondering what could be easier? echo?