10 Maj
2004
10 Maj
'04
23:10
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>
sorry już zapomniałem o jaką wersję chodziło, dla 1.2 będzie:
SELECT a.userid, period 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