Circuito Criterium Piceni & Pretuzi

[insert_php]
require ‘/web/htdocs/www.adriaticoteam.it/home/costanti.php’;
$db = mysqli_connect($hostname,$username,$password, $database);
if (mysqli_connect_errno()) {
echo “Failed to connect to MySQL: ” . mysqli_connect_error();
}
$year_clause = “AND data >= ‘2024-01-01’ AND data < '2024-12-31'"; [/insert_php]

[insert_php]

//Step2
$query = “SELECT * FROM gare where circuito LIKE ‘%Criterium%’ ” . $year_clause . ” ORDER BY data ASC”;
$result = mysqli_query($db, $query) or die(‘Error querying database.’);

//Step3
//$row = mysqli_fetch_array($result);

while ($row = mysqli_fetch_array($result)) {
echo ‘

‘;

}

//Step 4
mysqli_free_result($result);
mysqli_close($db);
[/insert_php]

Nome Disciplina Data Luogo Distanze
‘ . $row[“nome”] . ‘ ‘ . $row[“specialita”] . ‘ ‘ . $row[‘data’] . ‘ ‘ . $row[‘luogo’] . ‘ ‘ . $row[‘distanza’] . ‘