I use the following ASP code to allow me to create navigation links for a couple of web sites I host:

<!--#include file='dbconnect.asp'-->
<%
dim adoCn
dim strSQL
set adoCn = Server.CreateObject("ADODB.Connection")
adoCn.Open strConn
dim adoRs
strSQL = "Select * FROM tblPages order by ID Asc"
set adoRs = adoCn.Execute(strSQL)
%>&nbsp; <img border="0" src="images/bullet.jpg">&nbsp;
<%
Do While Not adoRs.EOF%>
<a href="ViewPage.asp?ID=<%=adoRs("ID")%>"><%=adoRs(" PageName")%></a>
&nbsp;

</td>
</tr>
</table>
</center>

tbl pages being in three sections: ID, Page Name and content

The Page name appears as the link in the nav menu, and when clicked on the content of the relavent field is displayed on the page. Basically it is a very simple content management system.

I've been asked to do something similar on a site hosted on Linux servers so I have to do the same job in PHP. Can someone suggest the best way to do this... thanks.

Neil