How can I make my mysql database records visible to search engines ? (part 2)

Question

Part 1: http://stackoverflow.com/questions/1749520/how-can-i-make-my-mysql-database-records-visible-to-search-engines

I have tried to figure out how to create a site-map for my classifieds website, however, I dont understand the way it works with php and database websites.

I have understood that I need all links on a html page, right? (this is no problem, I can easily create a new entry on one page every time an 'ad' is posted)

So, my questions are these:

1- What should the links point to in that one html page, to database records?

2- How can I add meta-descriptions and meta-keywords (meta tags) to every link, so that its easier for google-searchers to find an ad directly via a google search.

3- What role does .htaccess play in all this, or is it needed to alter it at all?

I would appreciate well explained answers.

Thanks

Answer 1

Sounds like you need to learn more about websites in general.

1) The links point to pages that display database information. You need to learn to program to get the data from the database and display it.

2) This is done on the pages themselves. You could keep this info in the database as well and pull the appropriate info for whatever page is being displayed.

3) .htaccess can be used to allow for one page to handle the displaying of all the ads. (among other things but this seems most relevant to this question)

If you need this done soon you should look to pay someone. Sounds like you have some learning to do.

Answer 2

It sounds like you should read a tutorial or a book about PHP/MySQL web development. You might want to start with something like this: http://www.freewebmasterhelp.com/tutorials/phpmysql. This page especially: http://www.freewebmasterhelp.com/tutorials/phpmysql/4.