select from mysql and export to a htm file with php!!

[schmack]

Hello everyone…

A bookmark file look like this (a very simple one!)::

 

-----------------------------------------------------------------------

<!DOCTYPE NETSCAPE-Bookmark-file-1>

<TITLE>Bookmarks</TITLE>

<H1>Bookmarks</H1>

<DL><p>

 

<DT><H3 FOLDED ADD_DATE="0000000000">SBm - date</H3>

<DL><p>

<DT><A HREF="http://www.uidesign.de/index.php?article_id=1&clang=1" >User Interface Design GmbH (UID) - Usability Engineering, Graphic Design, Software Development</A>

<DT><A HREF="http://www.usernomics.com/" >User Interface Design, Usability, Human Factors, & Ergonomics</A>

</DL><p>

 

 

</DL><p>

-----------------------------------------------------------------------

 

What I need to do is to get from a database a name of site (site_name) and de link of the site (site_link) and put it in the spotes it has to be in! example:::

 

-----------------------------------------------------------------------

<!DOCTYPE NETSCAPE-Bookmark-file-1>

<TITLE>Bookmarks</TITLE>

<H1>Bookmarks</H1>

<DL><p>

 

<DT><H3 FOLDED ADD_DATE="0000000000">SBm - date</H3>

<DL><p>

<DT><A HREF="site_link" >site_name</A>

<DT><A HREF="site_link" >site_name</A>

</DL><p>

 

 

</DL><p>

-----------------------------------------------------------------------

 

And export it to a file (ex: bookmark.htm).

 

In the [ ADD_DATE=0000000000] I can use <?php date("Y-m-d"); ?>

 

 

Thanks…  a real thanks