Amfphp i inner join greska...Koristim AMFPHP za jedan Internet informacioni sistem. SQL upit mi je sledeci:
Code:
SELECT a.*, b.*, c.*, d.* FROM `savings` AS a
INNER JOIN `banks` AS b ON a.bankID = b.bankID
INNER JOIN `interestPayment` AS c ON a.interestPaymentID = c.idinterestPayment
INNER JOIN `currency` AS d ON a.currencyTerm = d.idCurrency
WHERE b.visible=1 AND c.visible=1 AND d.visible=1 AND a.visible=1 AND savingsType=1 AND a.bankID IN ('$bankIDsArray[1]')
ORDER BY b.bankName ASC
SELECT a.*, b.*, c.*, d.* FROM `savings` AS a
INNER JOIN `banks` AS b ON a.bankID = b.bankID
INNER JOIN `interestPayment` AS c ON a.interestPaymentID = c.idinterestPayment
INNER JOIN `currency` AS d ON a.currencyTerm = d.idCurrency
WHERE b.visible=1 AND c.visible=1 AND d.visible=1 AND a.visible=1 AND savingsType=1 AND a.bankID IN ('$bankIDsArray[1]')
ORDER BY b.bankName ASC
Code:
bankIDsArray[1] ima vrednost 1,2,3,4,5,6,7,8,9,10 tako da je taj deo koda uredu.
bankIDsArray[1] ima vrednost 1,2,3,4,5,6,7,8,9,10 tako da je taj deo koda uredu.
Kao rezultat mi ispisuje ovo:
Code:
(mx.collections::ArrayCollection)#0
filterFunction = (null)
length = 0
list = (mx.collections::ArrayList)#1
length = 0
source = (Array)#2
uid = "62EBA3DF-4E58-9412-AE41-B348AF834C53"
sort = (null)
source = (Array)#2
(mx.collections::ArrayCollection)#0
filterFunction = (null)
length = 0
list = (mx.collections::ArrayList)#1
length = 0
source = (Array)#2
uid = "62EBA3DF-4E58-9412-AE41-B348AF834C53"
sort = (null)
source = (Array)#2
Molim Vas za pomoc, unapred hvala.
--
With The Best Regards,
Daniel Dulić, Web System Development
http://www.citysuteam.com
Telefon: +381 (0) 64 / 364 - 65 - 91
E-Mail: [email protected]
CitySu team, Web Services Company
Antona Aškerca 44/50,
24000 Subotica
CitySu team
