I'm pretty sure it's easy, but, as I'm not a php expert I really don't understand how to do this.
I have a table recording categories and one recording articles, their relation is the category id (id_cat)
my query is
$articoli=mysql_query("SELECT * FROM sayit_news n LEFT JOIN sayit_categorie c ON n.id_cat = c.id_cat GROUP BY n.id_cat ORDER BY n.titolo") or die(mysql_error());now the problem is this:
how do I display the results like this:
and so on?
Thanks for any help