October 14, 2008, 12:00:00 *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Please support SEO4smf further development donating here or use paypal button from left menu.
 
  Home   Forum   Help Search Directory Calendar Login Register    RSS 2.0 feedAtom feed


News
Please support SEO4smf further development donating here or use paypal button from left menu.
IT Resources
Pages: [1]
« previous next »
  Print  
Author Topic:

Random row

 (Read 1003 times)
0 Members and 1 Guest are viewing this topic.
spiderx
Jr. Member
**

Points: 3
Offline Offline

Posts: 62
« on: September 18, 2006, 11:54:31 »
Hi,

Is possible to get a random row in mysql ?


Logged
Regards
Spider X


TheGodFather
Administrator
Hero Member
*****

Points: 202
Offline Offline

Posts: 2570



WWW
« Reply #1 on: September 18, 2006, 18:28:11 »
select * from table order by rand() limit 1;

if you want more field increase your limit Smiley

Regards
Logged
█ Deleted Domains
█ Hostmaster Web Tools
█ Webmaster Web Tools
spiderx
Jr. Member
**

Points: 3
Offline Offline

Posts: 62
« Reply #2 on: September 19, 2006, 00:46:00 »
Thanks TGF. It's working ... Smiley Smiley Smiley

Logged
Regards
Spider X
Pages: [1]
  Print  
« previous next »
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.4 | SMF © 2006, Simple Machines LLC
Seo4Smf v0.2 © Webmaster's Talks
TinyPortal v0.9.7 © Bloc 		Valid XHTML 1.0! Valid CSS!