Nginx WordPress Rewrite

location / { index index.php; try_files $uri $uri/ /index.php?q=$uri&$args; } location ~ \.php$ { root /usr/share/nginx/html/hoteljapan.info; fastcgi_pass 127.0.0.1:9000; fastcgi_index index.php; fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; include fastcgi_params; try_files $uri =404; }

Select Hotel Datafeed

SELECT `hotel_id`,`hotel_name`,`addressline1`,`zipcode`,`city`,`state`,`star_rating`,`longitude`,`latitude`,`url`,`photo1`,`photo2`,`photo3`,`photo4`,`photo5`,`overview`,`rates_from` FROM `hotelen` WHERE `country_id`=3