string and arrays problem

alanita

Hello,
I have a problem with sending array/string over the pages.

my page "search.php" has the code:
<FORM name action= "searchresult.php" method="post">
<SELECT name="column_name[]" MULTIPLE>
<option value="field_a">a</option>
<option value="field_b">b</option>
<option value="field_c">c</option>
<option value="field_d">d</option>
</SELECT>

my page "searchresult.php:

if (isset($POST['column_name']))
{
echo "You submitted: " . join(', ', $POST['column_name']) . ".\n";
}

$strcondition = '';
$strcondition = $_POST['column_name'];
echo "strcondition is " . $strcondition;

$sql = "SELECT $strcondition, record_id
FROM tbl_data";
$result = mysql_query($sql)
or die("<font color=\"#FF0000\">Query Error</FONT>".mysql_error());

The problem is :

When I select a,b and c rows, the result printed on page searchresult.php is:

You submitted: field_a, field_b, field_c.
strcondition is Array
Query ErrorUnknown column 'Array' in 'field list'

Why $_POST['column_name'] in first call inside ""you submitted :" gives right string, and second time in line " strcondition is :" gives "Array" word and error in mysql statement?

Please help!

Thank you,

alanita

Hello,
I solved the problem, I needed to add join to the line:
$strcondition = join(', ', $POST['column_name']);
(old was $strcondition = $POST['column_name']; )

But I still have the problem on page searchresult.php
I need to print differnet functions names according to fileds selected. For example, if I select filed_a, then name of function called is "outputfiled_a", if I select field_b, then name is "outputfield_b".
If there is only one filed selected - I don't have problems, but if there are multiple fileds, then I don't know how to go through each of the filed in array $strcondition = $_POST['column_name']; or $ strcondition.

Please help!

this is example of code for only one field selected

$fn_name = 'output' . $strcondition; // make name for function to be called as , for exampe outputfield_a or outputfield_b

$fn_name ($row['record_id']) ; // call function on row from quiery result set