MYSQL question showing random row from database

[ryansdistrict]

MYSQL question showing random row from database

i am trying to mess around with tags on my site
i would like to show random row content from the available rows in my mysql table
i want to run something like the cloud of tags
how can i do this ?

Regards

[rsw686]

A SQL statement like the following would work.

SELECT * FROM tablename ORDER BY RAND() LIMIT 1

[ryansdistrict]

ye did this and loved it
but how much max links per page is good for seo
i dont want to create a page of links and having google skipping my pages
is it a good idea to have a cloud of links for forum topics in the footer ?

[rsw686]

I modified the sitemap.php from the SE04SMF mod. Then sign up for the free google webmasters program and submit your site map to them.

[ryansdistrict]

ok
how much max links per page is good for seo

[rsw686]

I don't remember it was like 2k. You should do a sitemap as well. I think google has a max of 2k-3k links per sitemap. Check their site to be sure.