Welcome to The Coorg Heaven , Coorg , India
SELECT room_type.*,room.fld_roomtype AS fld_room,room_type.fld_id as rid FROM tbl_mghotel_roomstype AS room_type LEFT JOIN tbl_roomstype AS room on room_type.fld_roomtype=room.fld_id WHERE room_type.fld_hotelid = '41590'mysqli_result Object
(
[current_field] => 0
[field_count] => 30
[lengths] =>
[num_rows] => 0
[type] => 0
)