[pmwiki-users] updating (MYSQL) tables

Sjaak van Werkhoven sj.vanwerkhoven at planet.nl
Tue Nov 6 03:03:57 CST 2007


Hi,

I have got a problem with selecting data from an SQL table. This table is
filled with new data using one form

(:update form table=protocol
fields=voorwaarde,conclusie,documentatie,akkoord,conc_sterkte,user
submit=post:)
(:input hidden user value={$Author}:)
||class=firstrow border=0 cellspacing=22 width=40%
||! Voorwaarde ||! Conclusie ||
||(:update textarea voorwaarde rows=3 cols=50:)|| (:update textarea
conclusie rows=3 cols=50:)||
||class=firstrow border=0 cellspacing=22 width=25%
||!Documentatie:    ||(:update file documentatie rows=1 cols=30:)||
||!Conclusie sterkte:||(:update select conc_sterkte from=concl_sterkte:)||
||!Akkoord:   ||(:update radio akkoord Ja:)Ja (:update radio akkoord Nee
checked=1:)Nee||
||(:update submit value="Submit Changes":)||[[
http://192.168.42.109/pmwiki/pmwiki.php?n=Main.HomePage?action=logout|Uitloggen]<http://192.168.42.109/pmwiki/pmwiki.php?n=Main.HomePage?action=logout%7CUitloggen%5D>
]
(:update end:)

and should be updated using another form:

(:update form table=protocol
fields=voorwaarde,conclusie,documentatie,conc_sterkte,akkoord, user
required=voorwaarde where=voorwaarde method=get:)
||border=1
||!Voorwaarde ||!Conclusie ||!Documentatie ||!Sterkte ||!Akkoord ||!User ||
||(: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}:)||
(:update submit value="Submit Changes":)
(:update end:)

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

greetings

Sjaak van Werkhoven

-- 
Sjaak van Werkhoven

Emotional Brain bv,
Louis Armstrongweg 78,
1311 RL Almere,
tel 036 546 83 46
fax 036 549 71 46
s.vanwerkhoven at emotionalbrain.nl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: /pipermail/pmwiki-users/attachments/20071106/3082b0b1/attachment.html 


More information about the pmwiki-users mailing list