Hi guys i have the following code which takes the database format yyyy/mm/dd and converts it to
dd/mm/yyyy at the moment my output for example says 06 October 2018 what code do i add to this to output
Saturday 06 October 2018 ?
my code is .....
$sql = "SELECT DATE, VENUE, PRICE FROM gigs ORDER BY DATE ASC";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo DATE("d F Y", strtotime($row['DATE']));
echo "<BR>";
echo "" .$row["VENUE"]. "<br><br>";
}
}
else {
echo "No Messages";
}
$conn->close();