phpBB.de

Code: Alles auswählen

<?php
$servername = "";
$username = "";
$password = "";
$dbname = "";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>
<select>
<?php
$sql = "SELECT FROM_UNIXTIME(date_from,'%Y-%m-%d %H:%i') as date_from
FROM mantis_plugin_Calendar_events_table AS mEV
INNER JOIN mantis_plugin_Calendar_relationship_table AS mRE ON mEV.id = mRE.event_id
INNER JOIN mantis_bug_table AS mTA ON mRE.bug_id = mTA.id
WHERE mTA.status = 10";

$result = $conn->query($sql);

if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo "<option>". $row["date_from"]. "</option>";
}
} else {
echo "0 results";
}
$conn->close();
?>