Revision: 9845
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at November 25, 2008 16:11 by fostersolutions
Initial Code
//connect to mysql and select db
$link1 = @mysql_connect("p50mysql39.secureserver.net","frontstreetdb","FrOntStEet223_")
or die("Could not connect to MySQL Server!");
@mysql_select_db("frontstreetdb") or die("Could not select database");
$query = 'SELECT c.category_name, p.* FROM tblProducts p
INNER JOIN tblProductCategory c on
p.prod_category = c.category_id;';
$result = mysql_query($query) or die(mysql_error());
$currentCategory = null;
$currentType = null;
if (mysql_num_rows($result)) {
echo "<ul>";
while ($row = mysql_fetch_assoc($result)) {
if ($currentCategory != $row['category_name']) {
if ($currentCategory !== null) {
echo '</ul></li>';
}
echo '<li>'.htmlspecialchars($row['category_name']).'<ul>';
$currentType = null;
}
echo '<li><a href="'.$row['File_Path'].'">'.htmlspecialchars($row['prod_name']).'</a></li>';
$currentCategory = $row['category_name'];
$currentType = $row['prod_name'];
}
echo "</ul></li></ul>";
mysql_close($link1);
}
?>
Initial URL
Initial Description
This will create a list grouped by the sorted field, which is an inner join on a category field.
Initial Title
Nested list from grouped sql
Initial Tags
mysql, php
Initial Language
PHP