Re: What wrong am I doing now?
| From: | Matijn Woudt | Date: | Wed, 24 Jul 2013 12:25:00 +0000 |
| Subject: | Re: What wrong am I doing now? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-321705@lists.php.net to get a copy of this message | ||
On Wed, Jul 24, 2013 at 2:19 PM, Karl-Arne Gjersøyen <karlarneg@gmail.com>wrote:
> 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'];
>
$rad['dato'] probably doesn't exist because you used DATE_FORMAT.
Either use $rad[0], or use the following SQL:
$sql = "SELECT DATE_FORMAT(dato, '%e-%c-%Y') AS dato FROM transportdokument
WHERE dato >= '2013-07-20' AND dato <= '2013-07-24' GROUP BY dato
DESC";
Regards,
Matijn