Hi, Just want to mention: ext/mysel is deprecated. Use MySQLi, or PDO_MYSQL instead. :) Regards, Sebastian 2013/7/24 Karl-Arne Gjersøyen <karlarneg@xxxxxxxxx> > http://www.php.net/manual/en/datetime.format.php have the solution. Sorry > for asking before I look at php.net!!! > > Karl > > ---------- Forwarded message ---------- > From: Karl-Arne Gjersøyen <karlarneg@xxxxxxxxx> > Date: 2013/7/24 > Subject: What wrong am I doing now? > To: PHP Mailinglist <php-general@xxxxxxxxxxxxx> > > > mysql> SELECT DATE_FORMAT(dato, '%e-%c-%Y') FROM transportdokument WHERE > dato >= '2013-07-20' AND dato <= '2013-07-24' GROUP BY dato DESC; > +-------------------------------+ > | DATE_FORMAT(dato, '%e-%c-%Y') | > +-------------------------------+ > | 24-7-2013 | > | 23-7-2013 | > +-------------------------------+ > 2 rows in set (0.00 sec) > > mysql> > > > // My PHP code looks like this. > // ----------------------------------------- > $sql = "SELECT DATE_FORMAT(dato, '%e-%c-%Y') FROM transportdokument WHERE > dato >= '2013-07-20' AND dato <= '2013-07-24' GROUP BY dato DESC"; > $resultat = mysql_query($sql, $tilkobling) or die(mysql_error()); > > while($rad = mysql_fetch_array($resultat)){ > $dato = $rad['dato']; > var_dump($dato); > > I gott NULL,NULL here and believe it is something with my PHP Source that > is wrong when using DATE_FORMAT. As you see above it work in terminal. > > I hope this not is off-topic for the list. If so, I am sorry for it and > hope you can give me advice about a good MySQL list for newbie's. > > Thanks again for your help! > > Karl > -- github.com/KingCrunch
