mysql dateformat print

  • jokerper
  • Novice
  • Novice
  • User avatar
  • Posts: 22

Post 3+ Months Ago

Hi,


I need some help to figure this problem out.

I got 2 tables where one of them is give me the correct format and the other one dont.

Code: [ Select ]

if (isset($_POST['udskrivaktiviteter'])) {
$pdf->Table('select date_format(date, "%d %m %Y") as Dato, headline as Aktivitet from aktivitet where date >= NOW() + INTERVAL - 1 DAY ORDER BY date');
}
if (isset($_POST['banetype'])) {
$banetype = $_POST['banetype'];
$pdf->Table('select date_format(dato, "%d %m %Y") as Dato, fornavn, efternavn, telefon, banetype from banevagter WHERE banetype = "'.$banetype.'" AND dato >= NOW() + INTERVAL - 1 DAY ORDER BY dato');
}
  1. if (isset($_POST['udskrivaktiviteter'])) {
  2. $pdf->Table('select date_format(date, "%d %m %Y") as Dato, headline as Aktivitet from aktivitet where date >= NOW() + INTERVAL - 1 DAY ORDER BY date');
  3. }
  4. if (isset($_POST['banetype'])) {
  5. $banetype = $_POST['banetype'];
  6. $pdf->Table('select date_format(dato, "%d %m %Y") as Dato, fornavn, efternavn, telefon, banetype from banevagter WHERE banetype = "'.$banetype.'" AND dato >= NOW() + INTERVAL - 1 DAY ORDER BY dato');
  7. }

I know the names one is dato a one is date.

Could it be in the mysql DB. I dont know how to check there?




Code: [ Select ]
10 03 2012
11 02 2012
11 02 2012
14 04 2012
14 04 2012
  1. 10 03 2012
  2. 11 02 2012
  3. 11 02 2012
  4. 14 04 2012
  5. 14 04 2012


Why???
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

Post Information

  • Total Posts in this topic: 1 post
  • Users browsing this forum: No registered users and 59 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.