Thanks Blaine...
U hav done a good job
Thanks..
Anees Muhammed
___________
----- Original Message ----
From: Blaine <apelouperdeu@xxxxxxxxx>
To: php-objects@xxxxxxxxxxxxxxx
Sent: Saturday, November 24, 2007 9:45:55 PM
Subject: Re: Random record from latest 10 entries...
In fact, but it is just use subselects to make any restriction what you
wanna to.
############ ######### ######### #
# OK.. NOW A COMPLETE EXAMPLE:
############ ######### ######### ##
CREATE TABLE Products (
Product_Id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
Name VARCHAR(100) NULL,
CreationDate DATETIME NULL,
Value DOUBLE NULL,
PRIMARY KEY(Product_ Id)
);
INSERT INTO Products
( Name, CreationDate, Value ) VALUES
( "Notebook" , "2007-11-21 13:49:00" , 4000 ),
( "Pen" , "2007-11-21 14:30:00" , 2 ),
( "Nike" , "2007-12-21 16:00:00" , 200 ),
( "Mouse" , "2007-12-22 17:30:00" , 50 ),
( "Chair" , "2007-12-22 18:10:00" , 50 ),
( "Book" , "2007-11-22 21:00:00" , 30 ),
( "Airplaine" , "2007-11-23 04:30:00" , 200000 ),
( "Key" , "2007-11-23 06:30:00" , 1 ),
( "CD Player" , "2007-11-24 16:30:00" , 30 ),
( "Ferrari" , "2007-11-24 18:30:00" , 120000 ),
( "Table" , "2007-11-24 22:30:00" , 100 ),
( "T-shirt" , "2007-11-25 22:30:00" , 10 ),
( "Red Glasses" , "2007-11-25 23:30:00" , 20 ),
( "Nice Hat" , "2007-11-25 23:55:00" , 50 ),
( "Drink" , "2007-11-26 02:30:00" , 15 ),
( "Chuch Norris Movie" , "2007-11-26 12:10:00" , 10 ),
( "DVD Player" , "2007-12-26 21:15:00" , 200 );
-- SOME SELECT WITH THE FILTERS AS YOU WISH
SELECT * FROM Products ORDER BY CreationDate DESC LIMIT 10;
-- USING THAT WITH THE RANDOM FUNCTION
SELECT * FROM ( SELECT * FROM Products ORDER BY CreationDate DESC LIMIT 10 )
as TheTenRecentRecords ORDER BY RAND() LIMIT 1;
############ #####
# on mysql:
############ #####
mysql>
mysql>
mysql>
mysql> CREATE TABLE Products (
-> Product_Id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
-> Name VARCHAR(100) NULL,
-> CreationDate DATETIME NULL,
-> Value DOUBLE NULL,
-> PRIMARY KEY(Product_ Id)
-> );
Query OK, 0 rows affected (0.01 sec)
mysql>
mysql> INSERT INTO Products
-> ( Name, CreationDate, Value ) VALUES
-> ( "Notebook" , "2007-11-21 13:49:00" , 4000 ),
-> ( "Pen" , "2007-11-21 14:30:00" , 2 ),
-> ( "Nike" , "2007-12-21 16:00:00" , 200 ),
-> ( "Mouse" , "2007-12-22 17:30:00" , 50 ),
-> ( "Chair" , "2007-12-22 18:10:00" , 50 ),
-> ( "Book" , "2007-11-22 21:00:00" , 30 ),
-> ( "Airplaine" , "2007-11-23 04:30:00" , 200000 ),
-> ( "Key" , "2007-11-23 06:30:00" , 1 ),
-> ( "CD Player" , "2007-11-24 16:30:00" , 30 ),
-> ( "Ferrari" , "2007-11-24 18:30:00" , 120000 ),
-> ( "Table" , "2007-11-24 22:30:00" , 100 ),
-> ( "T-shirt" , "2007-11-25 22:30:00" , 10 ),
-> ( "Red Glasses" , "2007-11-25 23:30:00" , 20 ),
-> ( "Nice Hat" , "2007-11-25 23:55:00" , 50 ),
-> ( "Drink" , "2007-11-26 02:30:00" , 15 ),
-> ( "Chuch Norris Movie" , "2007-11-26 12:10:00" , 10 ),
-> ( "DVD Player" , "2007-12-26 21:15:00" , 200 );
Query OK, 17 rows affected (0.00 sec)
Records: 17 Duplicates: 0 Warnings: 0
mysql> SELECT * FROM ( SELECT * FROM Products ORDER BY CreationDate DESC
LIMIT 1
0 ) as TheTenRecentRecords ORDER BY RAND() LIMIT 1
+----------- -+------- +-------- --------- ----+---- ---+
| Product_Id | Name | CreationDate | Value |
+----------- -+------- +-------- --------- ----+---- ---+
| 4 | Mouse | 2007-12-22 17:30:00 | 50 |
+----------- -+------- +-------- --------- ----+---- ---+
1 row in set (0.02 sec)
mysql> SELECT * FROM ( SELECT * FROM Products ORDER BY CreationDate DESC
LIMIT 1
0 ) as TheTenRecentRecords ORDER BY RAND() LIMIT 1
-> ;
+----------- -+------- +-------- --------- ----+---- ---+
| Product_Id | Name | CreationDate | Value |
+----------- -+------- +-------- --------- ----+---- ---+
| 4 | Mouse | 2007-12-22 17:30:00 | 50 |
+----------- -+------- +-------- --------- ----+---- ---+
1 row in set (0.02 sec)
mysql> SELECT * FROM ( SELECT * FROM Products ORDER BY CreationDate DESC
LIMIT 1
0 ) as TheTenRecentRecords ORDER BY RAND() LIMIT 1
-> ;
+----------- -+------- +-------- --------- ----+---- ---+
| Product_Id | Name | CreationDate | Value |
+----------- -+------- +-------- --------- ----+---- ---+
| 5 | Chair | 2007-12-22 18:10:00 | 50 |
+----------- -+------- +-------- --------- ----+---- ---+
1 row in set (0.00 sec)
mysql> SELECT * FROM ( SELECT * FROM Products ORDER BY CreationDate DESC
LIMIT 1
0 ) as TheTenRecentRecords ORDER BY RAND() LIMIT 1
-> ;
+----------- -+------- +-------- --------- ----+---- ---+
| Product_Id | Name | CreationDate | Value |
+----------- -+------- +-------- --------- ----+---- ---+
| 15 | Drink | 2007-11-26 02:30:00 | 15 |
+----------- -+------- +-------- --------- ----+---- ---+
1 row in set (0.00 sec)
mysql> SELECT * FROM ( SELECT * FROM Products ORDER BY CreationDate DESC
LIMIT 1
0 ) as TheTenRecentRecords ORDER BY RAND() LIMIT 1
-> ;
+----------- -+------- +-------- --------- ----+---- ---+
| Product_Id | Name | CreationDate | Value |
+----------- -+------- +-------- --------- ----+---- ---+
| 5 | Chair | 2007-12-22 18:10:00 | 50 |
+----------- -+------- +-------- --------- ----+---- ---+
1 row in set (0.00 sec)
############ ########
# And you cand do more...
############ ########
mysql> SELECT * FROM ( SELECT * FROM Products ORDER BY Value DESC LIMIT 5 )
as T
heFiveExpensiveReco rds ORDER BY RAND() LIMIT 1;
+----------- -+------- ---+----- --------- -------+- ------+
| Product_Id | Name | CreationDate | Value |
+----------- -+------- ---+----- --------- -------+- ------+
| 1 | Notebook | 2007-11-21 13:49:00 | 4000 |
+----------- -+------- ---+----- --------- -------+- ------+
1 row in set (0.00 sec)
mysql> SELECT * FROM ( SELECT * FROM Products ORDER BY Value DESC LIMIT 5 )
as T
heFiveExpensiveReco rds ORDER BY RAND() LIMIT 1;
+----------- -+------- -----+--- --------- --------- +-------+
| Product_Id | Name | CreationDate | Value |
+----------- -+------- -----+--- --------- --------- +-------+
| 17 | DVD Player | 2007-12-26 21:15:00 | 200 |
+----------- -+------- -----+--- --------- --------- +-------+
1 row in set (0.00 sec)
mysql> SELECT * FROM ( SELECT * FROM Products ORDER BY Value DESC LIMIT 5 )
as T
heFiveExpensiveReco rds ORDER BY RAND() LIMIT 1;
+----------- -+------- ----+---- --------- --------+ --------+
| Product_Id | Name | CreationDate | Value |
+----------- -+------- ----+---- --------- --------+ --------+
| 7 | Airplaine | 2007-11-23 04:30:00 | 200000 |
+----------- -+------- ----+---- --------- --------+ --------+
1 row in set (0.00 sec)
--
O Blaine - What the developing
/|\ should'nt have been
| thiagomata.blog. com
/ \
[Non-text portions of this message have been removed]
<!--
#ygrp-mkp{
border:1px solid #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px 14px;}
#ygrp-mkp hr{
border:1px solid #d8d8d8;}
#ygrp-mkp #hd{
color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px 0px;}
#ygrp-mkp #ads{
margin-bottom:10px;}
#ygrp-mkp .ad{
padding:0 0;}
#ygrp-mkp .ad a{
color:#0000ff;text-decoration:none;}
-->
<!--
#ygrp-sponsor #ygrp-lc{
font-family:Arial;}
#ygrp-sponsor #ygrp-lc #hd{
margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;}
#ygrp-sponsor #ygrp-lc .ad{
margin-bottom:10px;padding:0 0;}
-->
<!--
#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}
#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a{
text-decoration:none;}
#ygrp-vital a:hover{
text-decoration:underline;}
#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc{
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o{font-size:0;}
.MsoNormal{
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
.replbq{margin:4;}
-->
____________________________________________________________________________________
Be a better pen pal.
Text or chat with friends inside Yahoo! Mail. See how. http://overview.mail.yahoo.com/
[Non-text portions of this message have been removed]
