Can someone please help me with this. Once the Submit button is pressed
\nthe page shows <\/p>\n
select Date_Format(Start_Date,’%d-%b-%Y’) As Start_Date,Day,No_Of_Nights,CONCAT(‘\u00a3’, FORMAT(cost, 2)) as Cost ,Status,PageLink from Instead of showing a table of results. Any help would be greatly appreciated. Thank you.<\/p>\n https:\/\/wordpress.org\/plugins\/insert-php\/<\/p>\n","protected":false},"template":"","class_list":["post-6647040","topic","type-topic","status-publish","hentry","topic-tag-php"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/6647040","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/6647040\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=6647040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}web152-thenorth<\/code>.Dukes3 WHERE concatc = ‘August 2015’ ORDER BY Start_Date<\/p>\n<h1>Booking Information For No 3 Dukes Cottage<\/h1>\n\n<form method="post" action="http:\/\/dukescottages.com\/Newsite\/phppage\/">\n<input type="hidden" name="submitted" value="true"\/>\n\n<label>Search Month to See Availability Details and Prices:\n\n<select name="Category" id="Catergory">\n\n<option>Please Choose Month<\/option>\n<option>January 2015<\/option>\n<option>February 2015<\/option>\n<option>March 2015<\/option>\n<option>April 2015<\/option>\n<option>May 2015<\/option>\n<option>June 2015<\/option>\n<option>July 2015<\/option>\n<option>August 2015<\/option>\n<option>September 2015<\/option>\n<option>October 2015<\/option>\n<option>November 2015<\/option>\n<option>December 2015<\/option>\n<option>January 2016<\/option>\n<\/select>\n<\/label>\n<input type="submit"\/>\n<\/form>\n\n[insert_php]\n\nif (isset($_POST['submitted'])) {\n\ninclude('ftp:\/\/dukescottages.com\/Newsite\/wp-content\/themes\/theretailer\/Connection.php');\n\n$Category = $_POST['Category'];\n$criteria= $_POST['criteria'];\n$query = "select Date_Format(Start_Date,'%d-%b-%Y') As Start_Date,Day,No_Of_Nights,CONCAT('£', FORMAT(cost, 2)) as Cost ,Status,PageLink from <code>web152-thenorth<\/code>.Dukes3 WHERE concatc = '$Category' ORDER BY Start_Date";\n$result = mysqli_query($dbcon, $query) or die($query);\necho "<table>";\necho "<tr>\n<th>\nArrival\n<\/th>\n<th>\nArr Day\n<\/th>\n<th>\nNo Nights\n<\/th>\n<th>\nCost\n<\/th>\n<th>\nStatus\n<\/th>\n<th>\nLink\n<\/th>\n<\/tr>";\n\nwhile ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {\n\necho "<tr><td>";\necho $row['Start_Date'];\necho "<\/td><td>";\necho $row['Day'];\necho "<\/td><td>";\necho $row['No_Of_Nights'];\necho "<\/td><td>";\necho $row['Cost'];\necho "<\/td><td>";\necho $row['Status'];\necho "<\/td><td>";\necho $row['PageLink'];\necho "<\/td><\/tr>";\n}\n\necho "<\/table>";\n\n} \/\/ end of If Statement\n\n[\/insert_php]<\/code><\/pre>\n