I'm looking for suggestions on how to set up my navigation system using Postgresql and php...
Here's the dilemma... (Never attempted this before)
I have 2 sections that will share these categories below, Studies and Plans...
All of the data for Studies and Plans is stored in the same table since the information in both sections is related to the same project.
The Categories are:
Financial
Educational
Commercial
Medical
Residential
Government
Military
Transportation
Other
Additionally there are many sub-categories under each category.
I have entered the categories into a table named "cat", the sub-categories data in a table named "sub_cat" and the studies and plans data in a table called "case_plans"
Illustrated via phpPgAdmin...
case_plans:
<table>
<tbody>
<tr>
<th class="data">Column</th>
<th class="data">Type</th>
<th class="data">Not Null</th>
<th class="data">Default</th>
</tr>
<tr>
<td class="data1">id</td>
<td class="data1">integer</td>
<td class="data1">
<div align="center">NOT NULL</div>
</td>
<td class="data1">nextval('case_plans_id_seq'::regclass)</td>
</tr>
<tr>
<td class="data2">study</td>
<td class="data2">integer</td>
<td class="data2">
<div align="center">NOT NULL</div>
</td>
<td class="data2"></td>
</tr>
<tr>
<td class="data1">plan</td>
<td class="data1">integer</td>
<td class="data1">
<div align="center">NOT NULL</div>
</td>
<td class="data1"></td>
</tr>
<tr>
<td class="data2">model</td>
<td class="data2">text</td>
<td class="data2">
<div align="center"></div>
</td>
<td class="data2"></td>
</tr>
<tr>
<td class="data1">cat</td>
<td class="data1">text</td>
<td class="data1">
<div align="center"></div>
</td>
<td class="data1"></td>
</tr>
<tr>
<td class="data2">sqft</td>
<td class="data2">text</td>
<td class="data2">
<div align="center"></div>
</td>
<td class="data2"></td>
</tr>
<tr>
<td class="data1">title</td>
<td class="data1">text</td>
<td class="data1">
<div align="center"></div>
</td>
<td class="data1"></td>
</tr>
<tr>
<td class="data2">name</td>
<td class="data2">text</td>
<td class="data2">
<div align="center"></div>
</td>
<td class="data2"></td>
</tr>
<tr>
<td class="data1">location</td>
<td class="data1">text</td>
<td class="data1">
<div align="center"></div>
</td>
<td class="data1"></td>
</tr>
<tr>
<td class="data2">lgpic</td>
<td class="data2">text</td>
<td class="data2">
<div align="center"></div>
</td>
<td class="data2"></td>
</tr>
<tr>
<td class="data1">smpic</td>
<td class="data1">text</td>
<td class="data1">
<div align="center"></div>
</td>
<td class="data1"></td>
</tr>
<tr>
<td class="data2">inside</td>
<td class="data2">text</td>
<td class="data2">
<div align="center"></div>
</td>
<td class="data2"></td>
</tr>
<tr>
<td class="data1">inside1</td>
<td class="data1">text</td>
<td class="data1">
<div align="center"></div>
</td>
<td class="data1"></td>
</tr>
<tr>
<td class="data2">inside2</td>
<td class="data2">text</td>
<td class="data2">
<div align="center"></div>
</td>
<td class="data2"></td>
</tr>
<tr>
<td class="data1">lg2d</td>
<td class="data1">text</td>
<td class="data1">
<div align="center"></div>
</td>
<td class="data1"></td>
</tr>
<tr>
<td class="data2">sm2d</td>
<td class="data2">text</td>
<td class="data2">
<div align="center"></div>
</td>
<td class="data2"></td>
</tr>
<tr>
<td class="data1">lg3d</td>
<td class="data1">text</td>
<td class="data1">
<div align="center"></div>
</td>
<td class="data1"></td>
</tr>
<tr>
<td class="data2">sm3d</td>
<td class="data2">text</td>
<td class="data2">
<div align="center"></div>
</td>
<td class="data2"></td>
</tr>
<tr>
<td class="data1">pdf</td>
<td class="data1">text</td>
<td class="data1">
<div align="center"></div>
</td>
<td class="data1"></td>
</tr>
<tr>
<td class="data2">about</td>
<td class="data2">text</td>
<td class="data2">
<div align="center"></div>
</td>
<td class="data2"></td>
</tr>
<tr>
<td class="data1">need</td>
<td class="data1">text</td>
<td class="data1">
<div align="center"></div>
</td>
<td class="data1"></td>
</tr>
<tr>
<td class="data2">solution</td>
<td class="data2">text</td>
<td class="data2">
<div align="center"></div>
</td>
<td class="data2"></td>
</tr>
</tbody>
</table>
cat:
<table>
<tbody>
<tr>
<th class="data">Column</th>
<th class="data">Type</th>
<th class="data">Not Null</th>
<th class="data">Default</th>
</tr>
<tr>
<td class="data1">sid</td>
<td class="data1">integer</td>
<td class="data1">
<div align="center">NOT NULL</div>
</td>
<td class="data1">nextval('cat_sid_seq1'::regclass)</td>
</tr>
<tr>
<td class="data2">name</td>
<td class="data2">character varying</td>
<td class="data2">
<div align="center">NOT NULL</div>
</td>
<td class="data2"></td>
</tr>
<tr>
<td class="data1">alt</td>
<td class="data1">character varying</td>
<td class="data1">
<div align="center">NOT NULL</div>
</td>
<td class="data1"></td>
</tr>
</tbody>
</table>
sub_cat:
<table>
<tbody>
<tr>
<th class="data">Column</th>
<th class="data">Type</th>
<th class="data">Not Null</th>
<th class="data">Default</th>
</tr>
<tr>
<td class="data1">sid</td>
<td class="data1">integer</td>
<td class="data1">
<div align="center">NOT NULL</div>
</td>
<td class="data1">nextval('sub_cat_sid_seq'::regclass)</td>
</tr>
<tr>
<td class="data2">name</td>
<td class="data2">character varying</td>
<td class="data2">
<div align="center">NOT NULL</div>
</td>
<td class="data2"></td>
</tr>
<tr>
<td class="data1">type</td>
<td class="data1">character varying</td>
<td class="data1">
<div align="center">NOT NULL</div>
</td>
<td class="data1"></td>
</tr>
<tr>
<td class="data2">cat</td>
<td class="data2">character varying</td>
<td class="data2">
<div align="center">NOT NULL</div>
</td>
<td class="data2"></td>
</tr>
</tbody>
</table>
So first off, am I heading in the right direction? If so where or how rather, should I proceed to pull the data and group it appropriately?
Any help, suggestions and/or reference links are greatly appreciated.
