thanks so much, I've gotten a lot from that page of the mySQL
documentation... but I'm still needing little more help.  I am currently
using the following PHP to generate my page (with results displayed in
standard mySQL date and time formats):

   $db = mysql_connect("localhost", "username", "password");
   $result = mysql_query("SELECT * FROM table order by date",$db);
   $myrow = mysql_fetch_array($result));


Should I change my query to something like this:

      $result = mysql_query("SELECT *,DATE_FORMAT(date,'%m/%d/%y')) FROM
tableorder by date",$db);

I tried using that query, but then I didn't know how to get the formatted
date out of the array field in my PRINTF lines (what goes in the ["  "]?)

Should I use two different queries, so that I have $result1 and $result2,
then $myrow1 and $myrow2, like this:

     $result1 = mysql_query("SELECT * FROM table order by date",$db);
     $result2 = mysql_query("SELECT DATE_FORMAT(date,'%m/%d/%y')) FROM table
order by date",$db);
     $myrow1 = mysql_fetch_array($result1));
     $myrow2 = mysql_fetch_array($result2));

Thanks for everyone's time.... if not for newsgroups, I don't how I'd learn

Eric Schwinder

"Torgil Zechel" <[EMAIL PROTECTED]> wrote:
   > Checkout:
   > the function DATE_FORMAT(date,format) does what you want...

> > I have a mySQL database that I am using PHP to interface with.  I have
> > fields in the database that are DATE and TIME types.  Can I format these
> > values so that the user sees "September 15, 2001"  or  "2:00 PM"
> > instead of
> > "2001-09-15" and "14:00:00" when I show the values on the web page?
> >

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to