Jump to content

OzWaz2

New Members
  • Content Count

    5
  • Joined

  • Last visited

Community Reputation

0 Neutral

About OzWaz2

  • Rank
    Newbie
  1. Again Thanks Barand -Worked perfectly Appreciate you assistance and patience - as only us "old fogies" understand. Warren
  2. Of course - must be my age? So it is Great - Thank you BARAND. - IT WORKS Always good to have a fresh set of eyes from someone with more knowledge than me Can I stretch the friendship? The table displays in alphabetical order for the the NAME (pname) input. I would like it to display in chronologist order for the DATE (date) What would I need to do to get it to display in DATE order - with most recent on top? Thanks
  3. This is my display page that works <?php $conn = mysqli_connect("localhost", "root", "", "china"); $results = mysqli_query($conn, "SELECT * FROM image"); $image = mysqli_fetch_all($results, MYSQLI_ASSOC); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link href="css/basic.css" rel="stylesheet" type="text/css" /> <link href="css/img.css" rel="s
  4. Thanks for your help but I do not possess enough knowledge to correctly apply your suggested fix i have interpreted it as this: $results = mysqli_query($conn, "SELECT , name , comment , DATE_FORMAT(date, '%d/%m/%Y') as date FROM tablename); but it doesn't work What am i not understanding? Thanks Warren
  5. I have a simple mysql database holding information about an image upload including its 'name' and 'date uploaded' [current_timestamp()] to a folder 'image' I then display it into a table using the php ‘foreach’ facility. I want the date to be displayed in the ‘dd/mm/yyyy’ format. not the default yyyy/mm/dd. Here is the relevant code <?php $conn = mysqli_connect("localhost", "root", "", "dbname"); $results = mysqli_query($conn, "SELECT * FROM tablename"); $image = mysqli_fetch_all($results, MYSQLI_ASSOC); ?> <?php foreach ($image as $user): ?> <td&g
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.