| Новости | FAQ | Авторы | Документация | В действии | Библиотека |
| Инструменты | Полезные ссылки | Хостинги | Скачать | Примеры | Форум |
HL 16.09.2004 12:11
Идея:^connect[$connect_string]{$news[^table::sql{select *
from
u_letters
where l_to>=15 and l_to<=85 and letter_status='delivered'
}]}
<table border=1 width=100% valign=middle>
<tr align=center>
<td>
<b style='color:#333399'>#
</td>
<td>
<b style='color:#333399'>To Id:
</td>
<td>
<b style='color:#333399'>Letter<br>Status:
</td>
<td>
<b style='color:#333399'>Letter Content (ENG)
</td>
<td>
<b style='color:#333399'>Letter Translation (UKR)
</td>
<td>
<b style='color:#333399'>Answer<br>Status:
</td>
<td>
<b style='color:#333399'>Answer Content (UKR)
</td>
<td>
<b style='color:#333399'>Answer Translation (ENG)
</td>
<td></td>
</tr>
######data section
^if($news){
^news.menu{
<tr valign=top>
<form method="post">
<td align=center>
$news.letter_id
</td>
<td align=center>
$news.l_to
</td>
<td align=center>
<input type='text' value='$news.letter_status' name='letter_status' size=5>
</td>
<td align=justify>
<b>Subject:$news.l_subject<b><br>
<textarea name='l_eng' cols=60 rows=10>$news.l_eng</textarea>
</td>
<td align=justify>
<br>
<textarea name='l_ukr' cols=60 rows=10>$news.l_ukr</textarea>
</td>
<td align=justify>
<input type='text' value='$news.l_ans_status' name='l_ans_status' size=5>
</td>
<td align=justify>
<br>
<textarea name='l_ans_ukr' cols=60 rows=10>$news.l_ans_ukr</textarea>
</td>
<td align=justify>
<br>
<textarea name='l_ans_eng' cols=60 rows=10>$news.l_ans_eng</textarea>
</td>
<td>
<input type=submit value=submit name=posted>
</form>
^if(def $form:l_eng){
^connect[$connect_string]{
^void:sql{
update u_letters
set letter_status='$form:letter_status',
l_ans_status='$form:l_ans_status',
l_ukr='$form:l_ukr',
l_ans_ukr='$form:l_ans_ukr',
l_ans_eng='$form:l_ans_eng'
where letter_id='$news.letter_id'}}}
</td>
</tr>
}}
</table>