Koristim AMFPHP za povezivanje PHP-a i FLEX-a. Meni je potrebno da izvedem dva upitau PHPu, ali nikako neuspevam...
Prvi upit:
Code:
$sql = ("SELECT a.*, b.*, c.*, e.* FROM `cards` AS a
INNER JOIN `cardSystem` AS b ON a.cardSystem = b.idcardSystem
INNER JOIN `banks` AS c ON a.bankID = c.bankID
INNER JOIN `accountType` AS e ON a.cardAccount = e.idaccountType
WHERE a.bankID IN ($bankIDsArray[1]) AND a.cardSystem IN ($cardSystem[1]) AND a.cardType IN ('$cardType') AND a.cardCurrency IN ('$cardCurrency') AND a.visible = 1");
$query = mysql_query($sql);
return $query;
$sql = ("SELECT a.*, b.*, c.*, e.* FROM `cards` AS a
INNER JOIN `cardSystem` AS b ON a.cardSystem = b.idcardSystem
INNER JOIN `banks` AS c ON a.bankID = c.bankID
INNER JOIN `accountType` AS e ON a.cardAccount = e.idaccountType
WHERE a.bankID IN ($bankIDsArray[1]) AND a.cardSystem IN ($cardSystem[1]) AND a.cardType IN ('$cardType') AND a.cardCurrency IN ('$cardCurrency') AND a.visible = 1");
$query = mysql_query($sql);
return $query;
Drugi upit:
Code:
$sql = ("SELECT `idsecurity`, `securityName`, `visible` FROM `security` WHERE `visible`='1' AND idsecurity IN ('$securityID') ORDER BY `idsecurity`");
$query = mysql_query($sql);
return $query;
$sql = ("SELECT `idsecurity`, `securityName`, `visible` FROM `security` WHERE `visible`='1' AND idsecurity IN ('$securityID') ORDER BY `idsecurity`");
$query = mysql_query($sql);
return $query;
U drugom upitu $securityID treba da dobije iz prvog upita koji je u obliku "1,2,3".
Molim Vas za pomoc, unapred hvala.
Prijateljski pozdrav,
--
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