| | |
Select random database value?
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved |
i Got the result myself and answer is
bye
sql Syntax (Toggle Plain Text)
SELECT * FROM tablename ORDER BY RAND() LIMIT 0,30
bye
Last edited by peter_budo; Mar 30th, 2008 at 5:46 am. Reason: Keep It Organized - please use [code] tags
![]() |
Similar Threads
- Image Verification in Asp.net (ASP.NET)
- Select Random Number from Access Table Using C# (C#)
- ASP - Random values from database (ASP)
- please help me....asap! (Java)
- how VB get data from database randomly (Visual Basic 4 / 5 / 6)
- Can't get rid of random pop ups (Viruses, Spyware and other Nasties)
- ASP .NET Display Random records from the database (ASP.NET)
- Randomizing Database Questions (Java)
Other Threads in the PHP Forum
- Previous Thread: Previewing images before uploading
- Next Thread: SELECT and RETRIEVE MYsql Data...
| Thread Tools | Search this Thread |
Tag cloud for PHP
.htaccess 301 access ajax apache api array beginner binary broken cakephp checkbox class cms code compression cron curl database date directory display download dropdown dynamic echo email error file files folder form forms function functions google href htaccess html httppost image include insert integration ip java javascript joomla limit link login loop mail md5 menu methods mlm mod_rewrite multiple mysql oop parse paypal pdf php problem query radio random recursion regex remote script search secure select server sessions sms soap source space speed sql structure syntax system table tutorial update upload url validation validator variable video votedown web xml youtube





