/    Sign up×
Community /Pin to ProfileBookmark

Need data in database be on search engines.

I want to have a list of businesses stored in a database.
When some one does a search, a list will come up with a few businesses shown according tot he search criteria.
When one of the businesses is clicked on from the resultant list, the details of the business are shown.

I want the contents of the database to appear on search engines.
I can’t see how this would be possible if I am drawing that information out from a database??

Instead, I thought I could have code that after data was inserted into a database, it would write HTML pages of the data.
So, after a search was done, the links contained will be to these HTML pages.
This still doesn’t link the HTML pages created to the rest of the website as the search page with the results will still be via the database.

So, I thought I would also have a HTML link that lists all businesses.
(This page would be recreated everytime a record for a business was created or updated.)

By doing the above, I would hope to have an automated webite that is optimised for search engines??

Does all of the above make sense!?

Any feedback would be appreciated.

Thanks.

Jam

to post a comment
PHP

2 Comments(s)

Copy linkTweet thisAlerts:
@96turnerriApr 19.2005 — $sql = "SELECT * FROM buisnesses ORDER BY name ASC";

$result = mysql_query($sql) or die(mysql_error());

while($row = mysql_fetch_assoc($result)) {

echo $row["name"]."<br>";

}
×

Success!

Help @jammer20002 spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 6.17,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @nearjob,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,
)...