Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~615 People Reached
Favorite Forums
Favorite Tags
Member Avatar for dsgnews

Hi Friends, I need your help. Whenever I do a query on localhost it retrieves a value, but when I try on live it shows an error? What could be the problem?

Member Avatar for izzi
0
155
Member Avatar for dsgnews

Hi friends, I have very little knowledge of JOINs. Please, help me out in rewriting my sub-query to some kind of JOIN for earlier MySQL version TABLES IN MY DATABASE: 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, …

Member Avatar for angelo
0
94
Member Avatar for dsgnews

Hi friends, I have very little knowledge of JOINs. Please, help me out in rewriting my sub-query to some kind of JOIN for earlier MySQL versios. TABLES IN MY DATABASE: 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, …

Member Avatar for relawson
0
122
Member Avatar for dsgnews

Please, please, help me out in rewriting my sub-query to some kind of JOIN for earlier MySQL version: The query should retrive any availble rooms from the database MY ATTEMPTED SUB-QUERY: 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’ …

Member Avatar for demo
0
133
Member Avatar for dsgnews

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 …

Member Avatar for DanceInstructor
0
111