Hi,
I am trying the below sql statment:
mysql> select c.city, t.periodo, t.vitofferta from travel t, city c where
t.cityid=c.id and t.periodo>"2001-07-20" and
month(t.periodo)=month("2001-07-20") and
YEAR(t.periodo)=YEAR("2001-07-20") and rand() limit 7;
The result:
+-----------+------------+------------+
| city | periodo | vitofferta |
+-----------+------------+------------+
| Mauritius | 2001-07-21 | 2199 |
| Napoli | 2001-07-28 | 645 |
| London | 2001-07-31 | 345 |
| London | 2001-07-31 | 375 |
| London | 2001-07-31 | 375 |
| London | 2001-07-31 | 385 |
| London | 2001-07-31 | 385 |
+-----------+------------+------------+
Perfect. But when I try again I want it to display another sent of 7
records but it just keeps displaying the same.
+-----------+
| version() |
+-----------+
| 3.23.36 |
+-----------+
How do I do this.
Adrian
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
