group queries result
| From: | Barbara Picci | Date: | Mon, 13 Sep 2004 08:10:16 +0000 |
| Subject: | group queries result | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-196488@lists.php.net to get a copy of this message | ||
Hi all,
I've to extract data from a mysql db using two different queries and I must have an unique output sorting them alphabetically.
For istance,
query1: select * from ads where guest='PK';
count the number of results, make the difference between a given number and the number of results (variable $num).
query2: select from ads where guest='PK' limit $num;
now I have to export all results together sorting them.
How can I do that?
Can anyone help me?
Thanks in advance
Barbara
--