Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

Random sentence display

Jun 3, 2004, 7:10 PM
katabd
Veteran (1187 posts)
Jun 3, 2004, 7:10 PM
Post #1 of 2
Views: 4673
Shortcut
Quote Reply
Random sentence display
Hi

We have a big text (XML file that contains many statments as:


<dua>something....something</dua>

How can we display a random statment on a html pagr from that file?
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory
Jun 11, 2004, 2:14 PM
Alex
Administrator (9387 posts)
Jun 11, 2004, 2:14 PM
Post #2 of 2
Views: 4395
Shortcut
Quote Reply
Re: [katabd] Random sentence display In reply to
Is it in a database? If so, you can select from the database and use ORDER BY RAND(), LIMIT 1 to fetch one random row.

Cheers,

Alex
--
Gossamer Threads Inc.