|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
11-30-2003, 03:24 PM
|
#1 |
|
Confirmed User
Join Date: Jun 2002
Location: france
Posts: 996
|
quick php/mysql
i have a table with 1000 urls
what is the easyest way to display 20 random url's? |
|
|
|
11-30-2003, 03:36 PM
|
#2 |
|
Confirmed User
Industry Role:
Join Date: Jan 2003
Location: In a Tater Patch
Posts: 2,321
|
use this query select * from TABLE order by rand() limit 20
contact me if you want me to code somthing
__________________
Managed Hosting - Colocation - Network Services Yellow Fiber Networks icq: 19876563 |
|
|
|
|
11-30-2003, 03:48 PM
|
#3 | |
|
Confirmed User
Join Date: Jun 2002
Location: france
Posts: 996
|
Quote:
|
|
|
|
|
|
11-30-2003, 03:59 PM
|
#4 |
|
Confirmed User
Industry Role:
Join Date: Jan 2003
Location: In a Tater Patch
Posts: 2,321
|
no, it should pull 20 random rows open up a mysql client and run it a couple times.
__________________
Managed Hosting - Colocation - Network Services Yellow Fiber Networks icq: 19876563 |
|
|
|
|
11-30-2003, 04:35 PM
|
#5 | |
|
making it rain
Industry Role:
Join Date: Oct 2003
Location: seattle
Posts: 22,116
|
Quote:
|
|
|
|
|
