[mysql] jak zamienic wartosc w zapytaniu Opcje

[AndyPSV]

Jak zrobic:

[SQL] pobierz, plaintext 
q('SELECT id,id_u,amount,rate FROM `'.PRFX.'deals` WHERE sell = "'.$curr[$tab[$l2]]['t'].'" AND buy = "'.$curr[$tab[$l1]]['t'].'" AND date_end = "'.DATETIME_NO.'" ORDER BY <HERE>rate</HERE>, date ASC');
[SQL] pobierz, plaintext 

<HERE>if(rate == 0) rate = 3.1324;</HERE

zrobilem

[SQL] pobierz, plaintext 
q('SELECT id,id_u,amount,rate FROM `'.PRFX.'deals` WHERE sell = "'.$curr[$tab[$l2]]['t'].'" AND buy = "'.$curr[$tab[$l1]]['t'].'" AND date_end = "'.DATETIME_NO.'" ORDER BY replace(rate,"0","'.api::rate($curr[$tab[$l2]]['t'],$curr[$tab[$l1]]['t']).'"), date ASC');
[SQL] pobierz, plaintext 

Ten post edytował AndyPSV 6.11.2010, 06:07:36