help with array issues?

[lukeurtnowski]

I have an array ( poc[]) to hold all the selections made in a list box. But when I make any selection, and run the query;
$sql="select * from company, activity where c_id = a_c_id and
medivas in ('poc[0]' , '$poc[1]', '$poc[2]', '$poc[3]', '$poc[4]', '$poc[5]') and
a_date between '{$_POST['startdate']}' and '{$_POST['enddate']}'
and priority in ('{$_POST['prioritya']}', '{$_POST['priorityb']}', '{$_POST['priorityc']}')
GROUP BY c_name ORDER BY priority";
then I echo $sql;
I get
select * from company, activity where c_id = a_c_id and medivas in ('', '', '', '', '', '') and a_date between '2001-07-20' and '2005-01-05' and priority in ('A', 'B', 'C') GROUP BY c_name ORDER BY priority

It looks to me that it not seeing any poc[] variables, why?
Thanks.

[oraclable]

Can you show us how you fill the Array poc?
in the meantime, try to add some hard-coded values to the array and test.
e.g $poc[0]='val0'; $poc[1]='val1'

[lukeurtnowski]

sure, here is how I fill poc[]..

echo "<select name='poc[]' size='" . mysql_num_rows($query1) . "' multiple>";
    while($result1 = mysql_fetch_assoc($query1)) { 
    printf('<option value="'.$result1['medivas'].'">'.$result1['medivas'] . '</option>');
    print "\n";  
            }
    echo "</SELECT>"; 

[lukeurtnowski]

I tried testing it (like you said and I get the same result?
select * from company, activity where c_id = a_c_id and medivas in ('') and a_date between '2001-07-20' and '2001-07-20' and priority in ('A', 'B', 'C') GROUP BY c_name ORDER BY priority
Shouldn't it be ...medivas in ('any')...

    echo "<select name='poc[]' size='" . mysql_num_rows($query1) . "' multiple>";
$poc[0] = 'any';
    while($result1 = mysql_fetch_assoc($query1)) { 
    printf('<option value="'.$result1['medivas'].'">'.$result1['medivas'] . '</option>');
    print "\n";  
            }
    echo "</SELECT>"; 

[oraclable]

Did you declare an array in the next to recieve the values?

$ppoc=array();
$ppoc=$_GET["poc"];


and try ;
...medivas in ('$ppoc[0]' , '$ppoc[1]', '$ppoc[2]', '$ppoc[3]', '$ppoc[4]', '$ppoc[5]')...

[lukeurtnowski]

K, that worked I used echo $sql; to see the result, but now I get another error
select * from company, activity where c_id = a_c_id and medivas in ('test medivas (2)' , 'test medivas (3)', '', '', '', '')... and a_date between '2001-07-20' and '2001-07-20' and priority in ('A', 'B', 'C') GROUP BY c_name ORDER BY priority
You have an error in your SQL syntax near '... and a_date between '2001-07-20' and '2001-07-20' and priority in ('A', 'B'' at line 2

[lukeurtnowski]

got it thanks