[lms] Re: lista taryf

10 Maj 2004


      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

[lms] Re: lista taryf

Bartosz