[RESOLVED] array

[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 seing any poc[] variables, why?
Thanks.

[devinemke]

are you sure you don't mean $_POST['poc'] instead of $poc ?

[lukeurtnowski]

do you mean like this?

$sql="select * from company, activity where c_id = a_c_id and
medivas in ($POST['poc']) and
a_date between '{$POST['startdate']}' and '{$POST['enddate']}'
and priority in ('{$POST['prioritya']}', '{$POST['priorityb']}', '{$POST['priorityc']}')
its not rreturning anything

[lukeurtnowski]

I changed ($POST['poc']) to ('{$POST['poc']}') and all I got was the word "Array"

[lukeurtnowski]

got it thanks!