The simplest way of selecting random rows from the MySQL database is to use “ORDER BY RAND()” clause in the query.
Solution 1 [SQL QUERY]
SELECT * FROM `table` ORDER BY RAND() LIMIT 0,4;
This query select 4 random value every refresh?
The problem with this method is that it is very slow. The reason for it being so [...]
Archive for March, 2009
Select random value from MySQL database table.
Posted in MySql, PHP, tagged Database, function, My Blog, MySql, PHP, rand(), random, random value, return data, table on March 25, 2009 | 7 Comments »
How to active curl on xampp
Posted in Future Web, PHP, XAMPP, tagged CURL, PHP, php.ini, XAMPP on March 19, 2009 | 6 Comments »
Your xampp installation most likely already has curl support built-in. You just have to turn it on. It’s not difficult at all. That’s not necessary for Windows versions of PHP.
Find your php.ini file (probably in xampp\apache\bin\php.ini and open it in notepad or another plain text editor
search for the line that says:
;extension=php_curl.dll
remove the semicolon from the [...]
-
Blog Stats
- 28,185 hits
-
Recent Posts
My Calender
-
Recent Comments
jagoane on How to active curl on xam… Hari K T on About Me Pranjali on Breaking referential integrity… S.M. Saidur Rahman on OpenposbravoPOS Build from ope… Kai on OpenposbravoPOS Build from ope… -
Top Posts
- Openbravo POS systen intregation with MySql
- How to Get the Current Page URL
- Breaking referential integrity in MySql
- How to active curl on xampp
- Really Easy Field validation with Prototype
- Handy pagination PHP class with MySql
- PS Quotes for joomla 1.5.*
- Create XML file from mysql table
- Select random value from MySQL database table.
- How to make jQuery work on the same page with Mootools and or Prototype?
Our Tag
Archives
Categories
-
Top Clicks
My Twitter
- http://www.zoho.com/ 2 months ago
- http://developer.yahoo.com/performance/rules.html 5 months ago
- How to make jQuery work on the same page with Mootools & pro: http://digg.com/d1vASn?t 5 months ago
Pages
Meta
