Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re: Using SQL to create menu entries (was: Could u pls help me to solve....)

by Ryszard (Priest)
on Mar 19, 2003 at 11:36 UTC ( [id://244311]=note: print w/replies, xml ) Need Help??


in reply to Using SQL to create menu entries (was: Could u pls help me to solve....)

How about:
SELECT a.category_id, a.category FROM test a, test b WHERE b.main_category = a.category_id
From there you can make the individual menu split based on the category_id.

Warning: This is untested and may require some tweaking to make work in the exact way you require.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://244311]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others pondering the Monastery: (6)
As of 2024-03-28 11:09 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found