|
|
Posted by Piotr on 10/02/27 11:48
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 "<br>" . $row[$key]; //Show the results
}
}
Uytkownik "Piotr" <kefas@smk.gda.pl> napisa w wiadomoci
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" <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>
>>
>
>
Navigation:
[Reply to this message]
|