Posted by Piotr on 09/29/63 11:48

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" <zac.carey@gmail.com> napisal w wiadomosci
news:1148052883.690003.21170@j55g2000cwa.googlegroups.com...
> This seems to work...
>
> <?php
>
> 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.
> <FORM METHOD="POST" ACTION="<?=$self?>">
> <INPUT TYPE=checkbox NAME=FIELD[] value=field1>Checkbox 1<br>
> <INPUT TYPE=checkbox NAME=FIELD[] value=field2>Checkbox 2<br>
> <INPUT TYPE=checkbox NAME=FIELD[] value=field3>Checkbox 3<br>
> <INPUT TYPE="submit" NAME="submit">
> </FORM>
>

[Back to original message]