by passing city name, I take all hotels reviews among on the requested city groupin by hotel id and user id that reviews should be greater than 0, The query works correctly, but taking values using while loop it combines all the hotel review values together. How to take it as for each hotel.

Member Avatar for diafol

I think you need to supply more info. Your SQL query, yur current loop and fieldnames you wish to extract and format. This has been a recurring theme in your thread starters. Please make it easy for contributors.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.