Looping to print all data IF any data exists

[josephman1988]

Hey there!

 

Ok, I have a news table, and using the join function I put them in categories.

 

I want to know how I would go about a loop where if the category has at least one news item associated to it print the category name and all associated news items under it, if not, dont print the category.

 

QUERY

$newsarchive = mysql_query("
SELECT news.n_id, news.n_title, news.n_date, games.g_title, news.g_id
FROM games
LEFT JOIN news ON games.g_id = news.g_id
ORDER BY news.g_id
");

 

If you need more detail please just ask, and thanks in advanced!

Joe.

[Mchl]

How does the data returned by query look like? There's no column called category, so it's a bit hard to tell anything.

[premiso]

www.php.net/mysql_fetch_assoc()

 

www.php.net/foreach

 

<?php
$newsarchive = mysql_query("
SELECT news.n_id, news.n_title, news.n_date, games.g_title, news.g_id
FROM games
LEFT JOIN news ON games.g_id = news.g_id
ORDER BY news.g_id
");



while ($newsArray = mysql_fetch_assoc($newsarchive)) {
       foreach ($newsArray as $key => $val) {
             echo "Key: " . $key . " Val: " . $val . "<br />";
       }
}

?>

 

I think that is what you are looking for.

[josephman1988]

Thanks

 

But still because its looping over its still printing the category header for each entry rather then assigning all entries to one category.

 

Ho would i do this, thanks.