Query help
| From: | Matt Williams | Date: | Fri, 16 Nov 2001 15:20:53 +0000 |
| Subject: | Query help | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14397@lists.php.net to get a copy of this message | ||
Not really this list but I'm after a quick bit of help.
If I run this query
select count(room) from freerooms;
->83
and this
SELECT WEEK(MAX(date),1), WEEK(MIN(date),1)as totalweeks FROM booking;
->48 40
All good so far
now if I run this
SELECT count(f.room),WEEK(MAX(b.date),1), WEEK(MIN(b.date),1) FROM freero
oms f, booking b;
->+---------------+---------------------+---------------------+
| count(f.room) | WEEK(MAX(b.date),1) | WEEK(MIN(b.date),1) |
+---------------+---------------------+---------------------+
| 24817 | 48 | 40 |
+---------------+---------------------+---------------------+
It seems to be mulitplying out for some reason but I'm stuck as to how/why
and how to resolve it.
TIA
M: