dibi fórum

Ahoj,

potrebuji poradit s timto problemem.

<?php
SELECT ROUND(( UNIX_TIMESTAMP() - UNIX_TIMESTAMP(datum_narozeni)) /  (86400 * 365), 1)
?>

Tento SQL dotaz je v poradku. A pokud aplikuji slucovaci funkci CONCAT

<?php
SELECT  CONCAT(ROUND(( UNIX_TIMESTAMP() - UNIX_TIMESTAMP(datum_narozeni)) /  (86400 * 365), 1), ' test ')
?>

Tak DIBI zahlasi Fatal error: Uncaught exception ‚DibiException‘ with message 'SQL translate error: SELECT SQL_CALC_FOUND_ROWS CONCAT(ROUND / (86400 * 365), 1), Alone quotetest

V phpMyadminu se dotaz normalne provede. Pokousel jsem se i zaclenit modifikator %sql ale to same.

Muze me nekdo prosim nasmerovat?

Cela metoda vypada takto ( i kdyz to nebude dulezite )

<?php
        protected function getStatsPlayersData2($type)
        {
                $where = "";

                /*                                                                      'nejstarsi-hraci'       => 'Nejstarší hráči',
                                                                                        'nejmladsi-hraci'       => 'Nejmladší hráči',
                                                                                        'nejvyssi-hraci'        => 'Nejvyšší hráči',
                                                                                        'nejnizsi-hraci'        => 'Nejnižší hráči',
                                                                                        'nejtezsi-hraci'        => 'Nejtěžší hráči',
                                                                                        'nejlehci-hraci'        => 'Nejlehčí hráči',*/

                switch ($type)
                {
                        case 'nejstarsi-hraci':
                        $where = "datum_narozeni";
                        //$value = "UNIX_TIMESTAMP(datum_narozeni) ";
                        $value = "ROUND(( UNIX_TIMESTAMP() - UNIX_TIMESTAMP(datum_narozeni)) /  (86400 * 365), 1) ";
                        //$age = number_format((time() - $unix) / (86400 * 365), 1);
                        //$value = "UNIX_TIMESTAMP(datum_narozeni)";
                        $value2 = "datum_narozeni, ";
                        $sort  = "ASC";
                        break;

                        case 'nejmladsi-hraci':
                        $where = "datum_narozeni";
                        $value = "CONCAT(ROUND(( UNIX_TIMESTAMP() - UNIX_TIMESTAMP(datum_narozeni)) /  (86400 * 365), 1), 'test') "; // tady je takova jako chybka, u poradi ve vypisu pak nebude presne odpovidat, protoze to zaokrouhluji
                        $value2 = "datum_narozeni, ";
                        $sort  = "DESC";
                        break;

                        case 'nejvyssi-hraci':
                        $where = "vyska";
                        $value = "vyska";
                        $sort  = "DESC";
                        break;

                        case 'nejnizsi-hraci':
                        $where = "vyska";
                        $value = "vyska";
                        $sort  = "ASC";
                        break;

                        case 'nejtezsi-hraci':
                        $where = "vaha";
                        $value = "vaha";
                        $sort  = "DESC";
                        break;

                        case 'nejlehci-hraci':
                        $where = "vaha";
                        $value = "vaha";
                        $sort  = "ASC";
                        break;

                        // exit
                        default:
                                return;
                }

                $this->str = new Strankovani(COMPET_STATS_LIMIT, "l");
                $q = "  SELECT
                                SQL_CALC_FOUND_ROWS
                                ".$value." as _count,
                                ".$value2."
                                t2.jmeno as hrac_nazev,
                                t2.alternativni_jmeno,
                                t3.nazev as soutez_nazev,
                                t4.nazev as sezona_nazev,
                                t3.seo as soutez_seo,
                                t4.seo as sezona_seo,
                                t5.nazev as tym_nazev,
                                t5.seo as tym_seo,
                                n.ID as  zeme_id,
                                n.nazev as narodnost_nazev,
                                n.zkratka as narodnost_zkratka,
                                t1.hracID as hrac_id,
                                t1.tymID
                                FROM
                                soupisky t1
                                JOIN rejstrik_hraci t2 ON t2.ID = t1.hracID
                                JOIN souteze t3 ON t3.ID = t1.soutezID
                                JOIN sezony t4 ON t4.ID = t1.sezonaID
                                JOIN rejstrik_tymy t5 ON t5.ID = t1.tymID
                                JOIN narodnosti n ON n.ID = t2.narodnost
                                WHERE
                                soutezID = %i
                                AND sezonaID = %i
                                ORDER BY ".$where." ".$sort.",  hrac_nazev, hrac_id ASC
                                LIMIT ".$this->str->l.", ".$this->str->rows
                                ;


                $rows = DIBI::fetchAll($q, Compet::$selected_compet['ID'], Compet::$selected_season['ID']);
                $this->str->pocet_radku = $this->str->PocetRadku();
                DIBI::dump();

                return $rows;
        }
?>

Vypisovana chybka

<?php


Fatal error: Uncaught exception 'DibiDriverException' with message 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'test, '%Y-%m-%d')'

?>

Ja nevim :/

Editoval Kcko (22. 10. 2009 17:04)