php / mysql

[compuboy1010]

Was ist verkehrt an folgendem Format?

        $this->db->raw_query("SELECT TIME_FORMAT('e.time_s', '%k:%i'), TIME_FORMAT('e.time_e', '%k:%i'), 
                                     e.date_s, e.date_e, e.headline, e.summary, e.at, e.street, e.building, e.postalcode, e.city, e.info,
                                     c.*, pe.picture, pe.description 
                                FROM lnk_event_conductor AS lec, contacts AS c, events e
                           LEFT JOIN lnk_event_pic AS lep ON (e.id = lep.id_event)
                           LEFT JOIN pictures_events AS pe ON (lep.id_event = pe.id)
                               WHERE(e.lang = '".$this->language."')
                                 AND (e.id = '".$id."')
                                 AND (e.id = lec.id_event)
                                 AND (lec.id_conductor = c.id)"); 

Der gibt die time_s und time_e nicht aus.

[mrhappiness]

die felder heißen ja auch nicht mehr so...


TIME_FORMAT('e.time_s', '%k:%i') time_s, TIME_FORMAT('e.time_e', '%k:%i') time_e


sollte wieder gehen


warum machst du eigentlich kein print_r und schaust dir an, was in dem array so alles drinsteht?

[compuboy1010]

Das haut auch nicht hin:

        $this->db->raw_query("SELECT TIME_FORMAT('e.time_s', '%k:%i')time_s, TIME_FORMAT('e.time_e', '%k:%i')time_e, 
                                     e.date_s, e.date_e, e.headline, e.summary, e.at, e.street, e.building, e.postalcode, e.city, e.info,
                                     c.*, pe.picture, pe.description 
                                FROM lnk_event_conductor AS lec, contacts AS c, events e
                           LEFT JOIN lnk_event_pic AS lep ON (e.id = lep.id_event)
                           LEFT JOIN pictures_events AS pe ON (lep.id_event = pe.id)
                               WHERE(e.lang = '".$this->language."')
                                 AND (e.id = '".$id."')
                                 AND (e.id = lec.id_event)
                                 AND (lec.id_conductor = c.id)"); 

das Print_r zeigt, dass kein Wert vorhanden ist. Komisch

Array
(
[0] =>
[time_s] =>
[1] =>
[time_e] =>
[2] => 2004-03-19
[date_s] => 2004-03-19
[3] => 2004-03-20
[date_e] => 2004-03-20
...

[mrhappiness]

was auch durchaus verständlich ist, wieviel uhr ist denn der string e.time_s?

[compuboy1010]

Mein Gott,

Du weiß aber auch wirklich alles.
Unglaublich!!!!!!!!!!

1000 fach Dank und ein schönes Wochenende.

Gruß Compu