checkbox + columns

Helo,
I want to add some columns to display by checkboxes.
Each column would have it's own checkbos, and when is checked, this column
is shown in results (display).
How can I do so in php code ?
Can someone show any examle please ?
regards,
Piotr

Re: checkbox + columns

This seems to work...


include('path/to/connection/script'); //Connection Script

$table="table_name"; //Your table
$field= $_POST['FIELD']; //The fields submitted by the form below

if ($field)
{
$fields = implode($field, ","); //Proabably too crude but works for
now
$query = "SELECT $fields FROM $table;"; //The resulting query
$result = mysql_query($query) or die ("Couldn't execute query.");
while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
echo $row[$fields]; //Show the results
}
}

?>
//The 'values' and 'Checkbox descriptions' below could both be
dynamically generated but,
//in any event, the 'values' must match your table's column names.

Re: checkbox + columns

It works, but it only can view one column at a time in a results...
Is there a posability to view for examle 2 or 3 collumns at one time ?
regards,
piotr

Uzytkownik "strawberry" napisal w wiadomosci
news:1148052883.690003.21170@j55g2000cwa.googlegroups.com...
> This seems to work...
>
> >
> include('path/to/connection/script'); //Connection Script
>
> $table="table_name"; //Your table
> $field= $_POST['FIELD']; //The fields submitted by the form below
>
> if ($field)
> {
> $fields = implode($field, ","); //Proabably too crude but works for
> now
> $query = "SELECT $fields FROM $table;"; //The resulting query
> $result = mysql_query($query) or die ("Couldn't execute query.");
> while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
> {
> echo $row[$fields]; //Show the results
> }
> }
>
> ?>
> //The 'values' and 'Checkbox descriptions' below could both be
> dynamically generated but,
> //in any event, the 'values' must match your table's column names.
>

Re: checkbox + columns

I got the answare:
You just have to put another loop to review the table like that:

while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
foreach ($field as $key) {
echo "
" . $row[$key]; //Show the results
}
}



U¿ytkownik "Piotr" napisa³ w wiadomo¶ci
news:e51h86$1qf$1@news.task.gda.pl...
> It works, but it only can view one column at a time in a results...
> Is there a posability to view for examle 2 or 3 collumns at one time ?
> regards,
> piotr
>
> Uzytkownik "strawberry" napisal w wiadomosci
> news:1148052883.690003.21170@j55g2000cwa.googlegroups.com...
>> This seems to work...
>>
>> >>
>> include('path/to/connection/script'); //Connection Script
>>
>> $table="table_name"; //Your table
>> $field= $_POST['FIELD']; //The fields submitted by the form below
>>
>> if ($field)
>> {
>> $fields = implode($field, ","); //Proabably too crude but works for
>> now
>> $query = "SELECT $fields FROM $table;"; //The resulting query
>> $result = mysql_query($query) or die ("Couldn't execute query.");
>> while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
>> {
>> echo $row[$fields]; //Show the results
>> }
>> }
>>
>> ?>
>> //The 'values' and 'Checkbox descriptions' below could both be
>> dynamically generated but,
>> //in any event, the 'values' must match your table's column names.
>>

Re: checkbox + columns

This might look nicer... (well, I think so anyway ;-) )

echo "