Using array in mysql query

[stevenrhiggins]

We have to provide employees in our company with a simple facility to query our dbase, so we've created a form which allows them to select all the components in a "select" query.

The variables are then included in the query.

For example.

"select $fields from $table where $where $compare $condition order by $order"

$fields is an array derived from a multiple selection in the form. I need to include all the elements in the array in the query with the necessary commas. Of course I can get the commas into the array but I don't want a comma after the last element.

How can I do this? Thanks in advance!

[tasistro]

// on your form
<select name="fields[]" multiple> // note the brakets and the multiple
%your options code here%
</select>

<?
// then on your script

$sql_command="SELECT ";

for ($counter=0;$counter<(count(fields)-1);$counter++) {
$sql_command.=" ".fields[$counter].",";
}

$sql_command.=" ".fields[(count(fields)-1)];

$sql_commadn.="% the remaining part or your sql %";

?>

Saludos
Gerardo

[[deleted]]

implode()

$fields = array('foo','bar');
echo implode(',' , $fields);

[stevenrhiggins]

Thanks Vincent.

implode() works as you suggested. However I'm getting a "Supplied argument..." error.

$qfields=implode("," ,$field);

$query=mysql_query("select $qfields from $table where $where $compare $condition");

while ($row=mysql_fetch_row($query))

            {

            print"<tr>\n";

            foreach ($row as $value)

                    {

                    print"<td width='200' align='center'><font size='1' face='arial'>$value</font></td>";

                    }

            print"</tr>";

            print"<tr><td colspan='$numfields'><hr></td></tr>";

            }

Any suggestions? Thanks in advance!

[stevenrhiggins]

Found the problem. Once again Vincent, thanks for your help.

[[deleted]]

You're welcome.

---

YAPF! FAQ database and forum.
www.hvt-automation.nl/yapf/