Новости | 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>