Msql joining with PHP forum/catagories

ps2gamer


this code below outputs this:

[quote]
C: Forum Beta 1.0
News
C: Forum Beta 1.0
Post Testing
C: Maintenance
Bug Reports
C: Maintenance
Suggestions 
[/quote]


however, im trying to get it to do this:

[Quote]
C: Forum Beta 1.0
News
Post Testing
C: Maintenance
Bug Reports
Suggestions
[/Quote]

The C: represents catogories...everything else are forums

Is there something I can do to the query to fix this or is it only possible through PHP?  Thanks


<?php

if ($_GET['t'])
{
	show_source("test.php");
	exit;
}

$conn = mysql_connect("localhost", "nick_nick", "-----");
@mysql_select_db("nick_forum", $conn);


$result = mysql_query("SELECT * FROM sections,forums WHERE forums.section_id=sections.section_id");

while ($row = mysql_fetch_array($result))
{
	echo "C: " . $row['section_name'] . "\n<br>";
	echo $row['forum_name'] . "\n<br>";
}
?>

Weedpacket

You could look up GROUP BY in MySQL, but it might be simpler to use PHP (don't forget to sort on section) It's just a matter of thinking about what you want and what you need:

set $current_section to an empty string
select forum_name and section_name from etc.
Start the loop
if the current section_name is different from the $current_section, then this is the start of a new section. Print the section name and set $current_section to the section_name.
Either way, print the forum name.
Loop.

ps2gamer

Thanks, I got it to work

heres the code:

<?php

$conn = mysql_connect("localhost", "nick_nick", "-----");
@mysql_select_db("nick_forum", $conn);


$result = mysql_query("SELECT * FROM sections,forums WHERE forums.section_id=sections.section_id ORDER BY sections.section_sort,forums.forum_sort ASC");

$current_section = "";

while ($row = mysql_fetch_array($result))
{

if ($row['section_name'] != $current_section)
{
	$current_section = $row['section_name'];
	echo "<b>Section</b>: $current_section\n<br>";
}
echo $row['forum_name'] . "\n<br>";
}