I have a urgent MySQL test problems now.
The problems followings:
"-- this is a 10 x 10 grid representation of seats in a seating chart (100 seats total)
-- patrons can reserve seats that are adjacent to each other, in the same row (same y axis).
-- for example, Seat Id 11 (1,1) and 21 (2,1). They can not skip seats or reserve in different rows
-- given a selection of seats, we want to block off 2 seats to the left and 2 to the right, 1 above, and 1 below.
select * from seating_chart_grid;
-- if the patron has seats 11 and 21, the query should return ids 31, 41, 12, 22
-- if the patron has seat id 23 and 33, the query should return 13, 43, 53, 24, 34
-- if the patron has seat 44, the query should return 24, 34, 54, 64, 43, 45
"
If you can solve then please let me know immediately.
Thanks
I can get this done if we are allowed to use PHP in conjugation with MySQL. With only MySQL, I don't think its possible to achieve the logic you're aiming for.
I have expertise in database programming, designing and administration.
I can help you out for providing the solution.
Kindly come to chat for further discussion on your project.
READY TO WORK RIGHT NOW
Hi, Greetings!
I have 7+ years of the experience in same kind of
projects. If you are looking for a true Freelancer,
am the Right person for you. I am available almost
24-7 and am very responsive. I feel proud that I
am a trusted Freelancer who pleases almost every
single client. You can rest assure, your work will
be delivered well in advance of others, with
passion and accuracy.
Hello!
I am an experienced database adminstrator using SQL for a long time.
I have read your project description and I have the confidence that I can do it for you.
Please feel free to contact me and discuss more about the detail.
Best regards.