Not really this list but I'm after a quick bit of help.
If I run this query

select count(room) from freerooms;

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(,WEEK(MAX(,1), WEEK(MIN(,1) FROM freero
oms f, booking b;
| count( | WEEK(MAX(,1) | WEEK(MIN(,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.



PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to