Retrieving full record - separate via php

[barney0o0]

Its something that ive never thought about before, but im thinking if possible it would reduce the the db strain...

 

I have a db for menus. Rather than doing 8 differant queries from the same table, if it possible to pull down the whole record then, via php, echo each menu item specific to its id?

 

For example, if i do (menu recordset)

 

SELECT *
FROM mainmenu_en

 

can i then do something like

 

<?php echo $row_menu['link' WHERE ID=3]; ?>

 

I know its crude...but just a thought

 

Many thanks in advance

[Daniel0]

Well, you could select all the menu items and loop through them. You could then check the id inside the loop.