Posted by laverdir on 03/13/07 22:32

<?
$query = "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=xref.spis_id AND
xref.vrsta_id=" . $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:

SELECT spisi.id, spisi.naziv, spisi.spisatelj, spisi.najava, DATE_FORMAT
(spisi.vrijeme_stavljanja, '%e. %c. %Y. %k:%i') FROM spisi,
spis_vrsta_xref AS xref WHERE spisi.id=xref.spis_id AND
xref.vrsta_id="7" ORDER BY spisi.vrijeme_stavljanja DESC;


i guess that it has somethnig to do with '%e. %c. %Y. %k:%i' part of the
DATE_TIME parameters not escaped right, but the same parameters work
when querying only one table without conditional statement.

looking forward to see answers to this puzzle.

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

[Reply to this message]