Skip to main content

using random in php query-mysql

<?php
$res = mysql_query('SELECT COUNT(*) AS count FROM mytable');
$row = mysql_fetch_assoc($res);
$rows_count = $row['count']; // to get the count of rows in your table, then:
$r = mysql_query('SELECT * FROM mytable LIMIT '.mt_rand(1, $rows_count).', 1');
?>

Comments

Post a Comment

Popular posts from this blog

htaccess disable directory browsing, disable file listing, disable file access

There may be some personal or secure data in a file, that you want to hide from the end user, when it is viewed through a web browser. Ex: http://www.example.com/user_files/24/chat.txt In the above scenario, if the file "chat.txt" contains a secure data, and you dont want to allow end users to directly access the file, or to disable the file listing in the folder "user_files" or "24", use the below code in your .htaccess file inside "user_files" folder: Options -Indexes order allow,deny deny from all
Post a Comment
Read more

Joomla validate chrono forms using jquery

It is a common practice to use Chrono forms in our joomla site to setup various forms in the site, be it a contact us form, submit a ticket form, or whatever. I have set the option "validate form" to "No" under chronoform settings in admin panel, and also preferred to not include any js or css files. For validating the chrono forms, i prefer jquery. So first lets add jquery support in our joomla. It is quite simple: 1. Download jquery.js and jquery_min.js (1.4.2 version is enough) and place them in media/system/js folder of your joomla. 2. Edit libraries->joomla->html->html->behavior.php, and add the following function below the mootools() function: function jQuery($debug = null)     {         static $loaded;         global $mainframe;         // Only load once         if ($loaded) {    ...
Post a Comment
Read more

dropdown menu over flash banner

It is often annoying in some browsers when the dropdown menu at the top of the flash banner is displayed at the back of the flash. It can be corrected with some minor changes in the flash embed code: 1. for embed tag, add wmode="transparent" 2. add param to the object tag: <param name="wmode" value="transparent" />
Post a Comment
Read more