Hello all
Where can I edit the reservation query for a reservation.
I have 6 tables
Name Min Cap
T1 2 2
T2 2 4
T3 2 6
T4 2 8
T5 4 6
T6 8 10
When I make a reservation for 2 persons the systems always give me T4 with a capicity of 8.
That's what I do'n't want. In this case I want T1.
I think you all know why.
AND capicity >= number of persons ORDER BY capicity ASC
LIMIT 1
Bert