Forum PHP.pl

[PHP] pobierz, plaintext 
$q = mysql_query("SELECT SUM(`change`) AS ostatnie_zmiany FROM `price_check` order by id desc limit 6");
$a = mysql_fetch_array($q);
print "<br> $a[ostatnie_zmiany]";
[PHP] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT sum(`change`) AS ostatnie_zmiany FROM 
    (SELECT `change` FROM `price_check` ORDER BY id DESC LIMIT 6) temp
[SQL] pobierz, plaintext 

Cytat(Damonsson @ 27.08.2014, 16:25:38 )

[SQL] pobierz, plaintext 
SELECT sum(`change`) AS ostatnie_zmiany FROM 
    (SELECT `change` FROM `price_check` ORDER BY id DESC LIMIT 6) temp
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
$q = mysql_query("SELECT sum(`change`) FROM 
    (SELECT `change` FROM `price_check` ORDER BY id DESC LIMIT 6) ostatnie_zmiany");
$a = mysql_fetch_array($q);
[PHP] pobierz, plaintext