Posted by Rik on 03/13/07 22:49

laverdir <MOVE-RE_ME_laverdir@post.t-com.hr> wrote:

> <?
> $query =3D "SELECT " . $this->tabela3 . ".id, " . $this->tabela3 . =

> ".naziv, " . $this->tabela3 . ".spisatelj, " . $this->tabela3 . =

> ".najava, " . " DATE_FORMAT(" . $this->tabela3 . ".vrijeme_stavljanja,=
=

> '%e. %c. %Y. %k:%i') FROM " . $this->tabela3 . ", " . $this->tabela2 =
.. =

> " AS xref WHERE " . $this->tabela3 . ".id=3Dxref.spis_id AND =

> xref.vrsta_id=3D" . $this->DB->quote($vrsta) . " ORDER BY " . =

> $this->tabela3 . ".vrijeme_stavljanja DESC";
> ?>
>
> php query doesn't return formated date and time, while this works
> through console window:

Echo your query, and see the problem. You're messing up quotes.

-- =

Rik Wasmus
Posted on Usenet, not any forum you might see this in.
Ask Smart Questions: http://tinyurl.com/anel

• Next in forum: Re: Query inconsistency (MySQL vs PHP) -> DATE_FORMAT
• Prev in forum: Query inconsistency (MySQL vs PHP) -> DATE_FORMAT
• Thread view: Re: Query inconsistency (MySQL vs PHP) -> DATE_FORMAT

[Reply to this message]