make automatic table

[oaskedal]

Hi!

I have made a way to register :
1) a link title
2) a link address
3) choose a link-category (from a drop-down) or type in a new one (if nescessary)

Now I need to output all of this in a table. How do I do that?

I have made this code, but it doesn't work the way I'd like it to. I'd like it to display as follows:

1) Category

- put all links that have been registered with this category under here
2) Category
- put all links that have been registered with this category under here
3) Category
- put all links that have been registered with this category under here

.. and so on until all have been displayed

while($rad = mysql_fetch_assoc($resultat)) { 
		echo "<tr><td>";
		echo "<h4>".$rad['kategori']."</h4>";
		$sql_finn = "SELECT * FROM linker WHERE kategori LIKE '%" . $rad['kategori'] . "%'";
		$resultatet = mysql_query($sql_finn, $tilkobling);
		$raden = mysql_fetch_assoc($resultatet);
		echo "</td></tr><tr><td>";
		echo $raden['linknavn'];
		echo "</td></tr>";
}

[jrolands]

you can try something like this
start off with making a function to prevent typing the same code over and over again..

function links($category) {
	$result = mysql_query("SELECT * FROM linker WHERE kategori LIKE ".$category."'");
	if(!$result) {
		echo("Something went wrong".mysql_error());
	} else {
		while($row = mysql_fetch_assoc($result)) {
			echo "<tr><td>";
       			echo "<h4>".$category."</h4>";
			echo "</td></tr><tr><td>";
			echo $row['linknavn'];
			echo "</td></tr>"; 
		}
	}
}

then, get all the different categorys and use them to loop the links() function you just made..

$category_result = mysql_query("SELECT DISTINCT kategori FROM linker ORDER BY kategori DESC");
if(!$category_result) {
	echo("Something went wrong".mysql_error());
} else {
	while($category_array = mysql_fetch_array($category_result)) {
		links($category_array);
	}
}