Hi i am new to this, however, i feel i am learning and getting on with it. however i have ran into a problem.<\/p>\n
the insert php i have got working on this page but the results are not great in terms of they need formatting
\nhttp:\/\/luxor-lettings.com\/our-properties\/click-through\/<\/p>\n
but i want to get the results into a HTML table so i have attempted it on another page – i have attempted with the following code on this page:
\nhttp:\/\/luxor-lettings.com\/results-2\/<\/p>\n
<html> but i get get errors – any help appreciated<\/p>\n what should i be changing to get the results into a table? thanks<\/p>\n https:\/\/wordpress.org\/plugins\/insert-php\/<\/p>\n","protected":false},"template":"","class_list":["post-5902676","topic","type-topic","status-closed","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/5902676","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\/5902676\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=5902676"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n <head>
\n <title>Available Properties<\/title>
\n <\/head>
\n <body>
\n <table>
\n <thead>
\n <tr>
\n <td>Property Image<\/td>
\n <td>Property Description<\/td>
\n <td>Property Availability<\/td>
\n <\/tr>
\n <\/thead>
\n <tbody>
\n[insert_php]
\n$servername = “db567706584.db.1and1.com”;
\n$username = “username”;
\n$password = “password”;
\n$dbname = “db567706584”;
\n\/\/ Create connection
\n$conn = new mysqli($servername, $username, $password, $dbname);
\n\/\/ Check connection
\nif ($conn->connect_error) {
\n die(“Connection failed: ” . $conn->connect_error);
\n}
\n$sql = “SELECT Property Thumbnail URL<\/code>,Property Title4HTML<\/code>,Image Tag<\/code> FROM Properties<\/code>,Available<\/code> WHERE Property Available Flag<\/code> = Flag<\/code> AND Property Available Flag<\/code> = ‘2’”;
\n$result = $conn->query($sql);
\nif ($result->num_rows > 0) {
\n \/\/ output data of each row
\n while($row = $result->fetch_assoc()) {
\n [\/insert_php]
\n <tr>
\n <td>[insert_php] echo $row[‘Property Image’][\/insert_php]<\/td>
\n <td>[insert_php] echo $row[‘Property Description’][\/insert_php]<\/td>
\n <td>[insert_php] echo $row[‘Property Availability’][\/insert_php]<\/td>
\n <\/tr>
\n [insert_php]
\n }
\n} else {
\n echo “0 results”;
\n}
\n$conn->close();
\n[\/insert_php]
\n<\/tbody>
\n <\/table>
\n <\/body>
\n<\/html><\/p>\n