$i $row_q_ws[1] $row_q_ws[2] $row_q_ws[3] "; $i=$i+1; } mysql_close($linkdb); } function show_pres() { $db_name="workshop"; $linkdb=open_db($db_name); $q_ws="select id_reg, title, prez_author, afil, prez_src from ws_ro_05 where pres_yn=\"1\" order by date_reg asc" ; $rq_ws=mysql_query($q_ws); $i=1; while($row_q_ws=mysql_fetch_row($rq_ws)){ $name1=explode(".",$row_q_ws[4]); $name='/gpsm/ws_ro/stimm1/doc/presentations_sinaia/pdf/'.$name1[0].'.'.'pdf'; echo "
$i $row_q_ws[2]
$row_q_ws[1]
"; $i=$i+1; } mysql_close($linkdb); } function show_prg($id) { $db_name="workshop"; $linkdb=open_db($db_name); $q_ws="select id_reg, title, prez_src, prez_time, prez_author from ws_ro_05 where id_reg=$id" ; $rq_ws=mysql_query($q_ws); while($row_q_ws=mysql_fetch_row($rq_ws)){ $name1=explode(".",$row_q_ws[2]); $name='/gpsm/ws_ro/stimm1/doc/presentations_sinaia/'.$row_q_ws[2]; echo "
$row_q_ws[3]
$row_q_ws[4]
$row_q_ws[1]
"; } mysql_close($linkdb); } function show_prg_cancel($id) { $db_name="workshop"; $linkdb=open_db($db_name); $q_ws="select id_reg, title, prez_src, prez_time, prez_author from ws_ro_05 where pres_yn='0' and id_reg=$id" ; $rq_ws=mysql_query($q_ws); while($row_q_ws=mysql_fetch_row($rq_ws)){ echo "
$row_q_ws[3]
$row_q_ws[4]
$row_q_ws[1]
Cancelled
"; } mysql_close($linkdb); } function work_group($id_grp) { $db_name="workshop"; $linkdb=open_db($db_name); $q_ws="select groups.grp_name, membri.name from groups, membri, work_grp where (groups.id_grp=$id_grp and groups.id_grp=work_grp.id_grp) and work_grp.id_membru=membri.id order by membri.name"; $rq_ws=mysql_query($q_ws); while($row_q_ws=mysql_fetch_row($rq_ws)){ $membr=$membr.' '.$row_q_ws[1]. '; '; } echo "
$membr
"; mysql_close($linkdb); } ?> Show presentations
Solar - Terrestrial Interactions
from Microscale to Global Models
September 6-10, 2005