mysql> SELECT a.userid, period, FROM_UNIXTIME(datefrom), FROM_UNIXTIME(dateto) FROM assignments a, tariffs t, users u WHERE u.id = a.userid AND t.id = a.tariffid AND deleted =0 AND t.name ='Internet'; ERROR 1054: Unknown column 'datefrom' in 'field list' mysql>

-----Original Message----- From: lms-bounce@lists.rulez.pl [mailto:lms-bounce@lists.rulez.pl] On Behalf Of A.L.E.C Sent: Thursday, May 06, 2004 7:28 PM To: lms@lists.rulez.pl Subject: [lms] Re: lista taryf

sprawdź jeszcze

SELECT a.userid, period, FROM_UNIXTIME(datefrom), FROM_UNIXTIME(dateto) FROM assignments a, tariffs t, users u WHERE u.id = a.userid AND t.id = a.tariffid AND deleted =0 AND t.name ='Internet'

-- Pozdrawiam Aleksander Machniak http://k27.prv.pl/alec gg-2275252