How to drive all the news of one category into an array?

Question

PHP

Hello, I want to add all the news of one category to 1 array, I did it like this but it doesn’t work

$cat = "it-new";
$resultat = mysql_query("SELECT * FROM `cms_v1.2` WHERE `Categoria` = $cat",$db);
$data = mysql_fetch_array($resultat);
print_r ($resultat);

Answer 1

$cat = "it-new";
$result = mysqli_query($db, "SELECT * FROM `cms_v1.2` WHERE `Categoria` = " . $cat);
$data = array();
while ($row = mysqli_fetch_assoc($result))
{
$data[] = $row;
}
print_r($data);