Any ideas? Anyone?
Look, there many ways to integrate PHP with Flex and one of the most easy methods is by using HTTPService, and I think this link well better show you how things work just follow it http://livedocs.adobe.com/flex/3/html/help.html?content=data_access_2.html
You can also go beyond this stage and use Zend Framework, but until now you can simply adress the php file you need.
If this helped you we need your feedback by clicking the right evaluation button
Thanks for the reply, but my question was actually a bit more specific.
Your first example wont work because you have 2 variables but only one bind element in the query. I'm not sure of the second example because I've only ever used paramaterized queries with a variable that I wish to bind to a column. What you're doing is trying to build a query (the in clause), and I'm not sure if that will work. Can you run your PHP code on its own to test?
The way you're calling your remote function is correct.
I'm inclined to go the array route and build your query manually. I.e.
$clause = '(';
foreach($categories as $value)
$clause .= "$value, ";
$clause = substr($clause, 0, -2);
$clause .= ')';
$query = ...
Also you can't echo out your query etc to test (when using via Flex), but you can write to a text file. I recommend that technique and / or using the test operation in Flash Builder and / or calling your PHP code independently of Flex to test.