group queries result
| From: | Barbara Picci | Date: | Fri, 10 Sep 2004 19:02:56 +0000 |
| Subject: | group queries result | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-196485@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
--