Claires Nannies - Jobs

Jobs

connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT Index, Title, Description, Salary, Date-added FROM tblVacancies ORDER BY Index DESC LIMIT 10"; echo ''; if ($result = $conn->query($sql)) { while ($row = $result->fetch_assoc()) { $row_id = $row["id"]; $row_sensor = $row["sensor"]; $row_location = $row["location"]; $row_value1 = $row["value1"]; $row_value2 = $row["value2"]; $row_value3 = $row["value3"]; $row_value4 = $row["value4"]; $row_value5 = $row["value5"]; $row_value6 = $row["value6"]; $row_value7 = $row["value7"]; $row_value8 = $row["value8"]; $row_reading_time = $row["reading_time"]; echo ''; } $result->free(); } $conn->close(); ?>
Index Title Description Salary Date-added
' . $row_id . ' ' . $row_sensor . ' ' . $row_location . ' ' . $row_value1 . ' ' . $row_value2 . ' ' . $row_value3 . ' ' . $row_value4 . ' ' . $row_value5 . ' ' . $row_value6 . ' ' . $row_value7 . ' ' . $row_value8 . ' ' . $row_reading_time . '