I'm close I think to passing the multiple arguments.

On a test page, this sql embedded works

<?php
global $user;
$result = db_query("SELECT node.uid FROM {node}
WHERE node.type = 'profile'");
$member = db_fetch_object($result);
return "$member->uid";
while($member = db_fetch_object($result)){
print "$member->uid";
print ",";
}
?>

I end up with "37, 31, 2"

But I need to use "return" in the argument php code

if I use

while($member = db_fetch_object($result)){
return "$member->uid";
}

at the end, still only the first one is passed, not multiple values.

anyone give me a pointer?



On 20/11/2010 10:21, Idan Arbel wrote:
if you want to view to take them into account as using "AND" then return them like so: 12+32+34, if you want it to take them into account as or return them as so 12,32,34.

don't forget to check to box in the argument settings area to accept multiple arguments

On Sat, Nov 20, 2010 at 3:14 PM, Neil Coghlan <neil@esl-lounge.com> wrote:
I have a view where I have selected User:uid as an argument and I am
using a sql query in the "Provide Default Argument" part. The problem
is, usually, the sql query is passing muliple UIDs back. How would I
pass all of them into the argument to be used by the view.

At the moment, the view is only taking the first one.

so, here is a simplified version of my php code:

global $user;
$result = db_query("SELECT node.uid FROM {node}
WHERE node.type = 'profile'");
$member = db_fetch_object($result);
return "$member->uid";

on my current db, this returns 3 UIDs...the view only takes the first one.

Thanks

Neil


--
[ Drupal support list | http://lists.drupal.org/ ]