Hi everyone, this is my first time using daniweb, so helo!
I have a major issue with building a menu from a query.
I have the following, a query built from a join
from 4 tables
my query returns the following
Id cat name sub 2sub con
3 1 axle flat round 7
4 1 axle metal round 7
5 1 axle plas round 7
6 1 axle woo round 7
7 1 pod metal round 6
8 1 pod plas round 6
9 1 pod woo round 6
the con column identifies it as an axle or a pod.
each line is actualy supposed to be a link.
I have been trying to build somthing like this:
<a href=3>flat round </a>
<a href=4>metal round </a>
<a href=5>plas round </a>
<a href=6>woo round </a>
the real query returns about a hundred rows formated the same way.
Is it possible to build a menu from this??
So far ive found 2 possible solutions ,
1. Ive found a few functions that create menus but they require a parent id and since my menu is built in various tables it wont work unless I redo everything.
2. Ive been trying out some arrays, but I cant get it working,
I am dieing here , has anyone faced a similar problem and can guide me???
thanks a lot.