Hi,<br><br>I have got a problem with selecting data from an SQL table. This table is filled with new data using one form<br><br><span style="color: rgb(51, 102, 255);">(:update form table=protocol fields=voorwaarde,conclusie,documentatie,akkoord,conc_sterkte,user submit=post:)
</span><br style="color: rgb(51, 102, 255);"><span style="color: rgb(51, 102, 255);">(:input hidden user value={$Author}:)</span><br style="color: rgb(51, 102, 255);"><span style="color: rgb(51, 102, 255);">||class=firstrow border=0 cellspacing=22 width=40%
</span><br style="color: rgb(51, 102, 255);"><span style="color: rgb(51, 102, 255);">||! Voorwaarde ||! Conclusie ||</span><br style="color: rgb(51, 102, 255);"><span style="color: rgb(51, 102, 255);">||(:update textarea voorwaarde rows=3 cols=50:)|| (:update textarea conclusie rows=3 cols=50:)||
</span><br style="color: rgb(51, 102, 255);"><span style="color: rgb(51, 102, 255);">||class=firstrow border=0 cellspacing=22 width=25%</span><br style="color: rgb(51, 102, 255);"><span style="color: rgb(51, 102, 255);">
||!Documentatie: ||(:update file documentatie rows=1 cols=30:)||
</span><br style="color: rgb(51, 102, 255);"><span style="color: rgb(51, 102, 255);">||!Conclusie sterkte:||(:update select conc_sterkte from=concl_sterkte:)||</span><br style="color: rgb(51, 102, 255);"><span style="color: rgb(51, 102, 255);">
||!Akkoord: ||(:update radio akkoord Ja:)Ja (:update radio akkoord Nee checked=1:)Nee||</span><br style="color: rgb(51, 102, 255);"><span style="color: rgb(51, 102, 255);">||(:update submit value="Submit Changes":)||[[
<a href="http://192.168.42.109/pmwiki/pmwiki.php?n=Main.HomePage?action=logout%7CUitloggen%5D" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://192.168.42.109/pmwiki/pmwiki.php?n=Main.HomePage?action=logout|Uitloggen]
</a>]</span><br style="color: rgb(51, 102, 255);">
<span style="color: rgb(51, 102, 255);">(:update end:)</span><br><br>and should be updated using another form:<br><br><span style="color: rgb(51, 102, 255);">(:update form table=protocol fields=voorwaarde,conclusie,documentatie,conc_sterkte,akkoord, user required=voorwaarde where=voorwaarde method=get:)
</span><br style="color: rgb(51, 102, 255);"><span style="color: rgb(51, 102, 255);">||border=1</span><br style="color: rgb(51, 102, 255);"><span style="color: rgb(51, 102, 255);">||!Voorwaarde ||!Conclusie ||!Documentatie ||!Sterkte ||!Akkoord ||!User ||
</span><br style="color: rgb(51, 102, 255);"><span style="color: rgb(51, 102, 255);">||(:update
text voorwaarde value={$voorwaarde}:)||(:update text conclusie
value={$conclusie}:)||(:update text documentatie
value={$documentatie}:)||(:update text conc_sterkte value={$conc_sterkte}:)||(:update text akkoord value={$akkoord}:)||(:update text user value={$user}:)||
</span><br><span style="color: rgb(51, 102, 255);">(:update submit value="Submit Changes":)</span><br style="color: rgb(51, 102, 255);"><span style="color: rgb(51, 102, 255);">(:update end:)</span><br><br>As
you can see I had trouble with filling the last form with the data from
the SQL table. Can someone tell me how to get this data available
within the last form?
Is there a possibility to get more examples using MYSQL tables within wiki pages? I<br><br>greetings<br><br>Sjaak van Werkhoven<br clear="all"><br>-- <br>Sjaak van Werkhoven<br><br>Emotional Brain bv,<br>Louis Armstrongweg 78,
<br>1311 RL Almere,<br>tel 036 546 83 46<br>fax 036 549 71 46<br><a href="mailto:s.vanwerkhoven@emotionalbrain.nl">s.vanwerkhoven@emotionalbrain.nl</a>