What is wrong with my My SQL query
 

Hey folks, I need your help. I stuck with my Database project.
I have five tables on the database: These are

Room, Guest, Booking, Employee and Admin

Room (room_ no, room_ type, price)
Guest (guest_ no, Fname, Sname, address,…)
Booking (room_no, guest_no, Fname, Sname, arrival_date,
departure_date, emp_no, user_name, password)
Employee (emp_no, Fname, Sname, uaser_name, password)
Admin (admin_no, fname, Lname, user_name, password)

I used the fallowing query to search for available rooms:

Select *
From Room R
Where R.room_no
NOT IN (Select B.room_no
From R.room_no = B.room_no
And R.room_type = ‘single’
And B.arrival_date = ‘2005-03-16’
And Bdeparture_date = ‘2005-04-19’

Q1. Whenever I do a query on localhost it retrieves a value, but when I try on live it shows an error. Please, tell me what the problem in this query could be?

Q2. Does MySQL use different SQL query such as like PL SQL or is it the similar query?

Q3.Is their any simple query than this.

Thanks for all your help.

DSG

Re: What is wrong with my My SQL query
 

Windows doesn't care about capital letters. Linux/Unix does.




Michael

Re: Please help me out with MySQL query
 

well if it works on localhost, then the code is fine. There's probably a problem with the server you're trying to connect to. What error do you get?

Re: What is wrong with my My SQL query
 

THIS WAS THE ERROR CODE:

#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near
'SELECT R.room_no
FROM room R, Booking B
WHERE R.room_no = B.roo

Re: Please help me out with MySQL query
 

Are you using a scripting language to send the query? Like php or asp? If so you will need to post the code you are using to submit the query.