Simple Machines Community Forum

General Community => Scripting Help => Aiheen aloitti: ryansdistrict - maaliskuu 03, 2008, 11:17:05 AP

Otsikko: MYSQL question showing random row from database
Kirjoitti: ryansdistrict - maaliskuu 03, 2008, 11:17:05 AP
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
Otsikko: Re: MYSQL question showing random row from database
Kirjoitti: rsw686 - maaliskuu 03, 2008, 02:29:13 IP
A SQL statement like the following would work.

SELECT * FROM tablename ORDER BY RAND() LIMIT 1
Otsikko: Re: MYSQL question showing random row from database
Kirjoitti: ryansdistrict - maaliskuu 03, 2008, 02:39:28 IP
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 ?
Otsikko: Re: MYSQL question showing random row from database
Kirjoitti: rsw686 - maaliskuu 03, 2008, 02:44:33 IP
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.
Otsikko: Re: MYSQL question showing random row from database
Kirjoitti: ryansdistrict - maaliskuu 03, 2008, 02:55:40 IP
ok
how much max links per page is good for seo
Otsikko: Re: MYSQL question showing random row from database
Kirjoitti: rsw686 - maaliskuu 03, 2008, 02:57:03 IP
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.