[thelist] mysql help
Bill Moseley
moseley at hank.org
Sun Oct 1 20:48:09 CDT 2006
On Mon, Oct 02, 2006 at 01:18:08AM +0100, Mark Mckee wrote:
> hi
>
> how can i thank you enough. iw as toying with the idea of having a
> second sql statement but had no idea how to implement it
Mark, I'd just "select * from info order by category, title" then in a
loop watch for a change in category and print a new heading.
Overkill, but maybe you need two tables? One for category and one for
links? Then in (fake) code that abstracts your tables and knows the
relationships between the tables you do:
for $cat in $category->select_all;
print $cat;
for $link in $cat->links {
print $link;
}
}
--
Bill Moseley
moseley at hank.org
More information about the thelist
mailing list