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();

    Read the PHP manual documentation on date and you will likely do something like:

    echo date("l d F Y", strtotime($row['DATE']));

      Thank you very much i just added D as well. much appreciated.

        Write a Reply...