>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
