function open_db($name_db)
{
$db=mysql_connect("localhost","costel", "costel1879");
if(!$db){
echo "Error -- Cannot connect to database";
exit;
}
mysql_select_db($name_db);
return $db;
}
function show()
{
$db_name="workshop";
$linkdb=open_db($db_name);
$q_ws="select id_reg, title, authors, afil, abstract, abstr_yn from ws_ro_07 order by date_reg asc" ;
$rq_ws=mysql_query($q_ws);
$i=1;
while($row_q_ws=mysql_fetch_row($rq_ws)){
if($row_q_ws[5]==1 && $row_q_ws[1]){
echo "
";
$i=$i+1;
}
}
mysql_close($linkdb);
}
function show_reg()
{
$db_name="workshop";
$linkdb=open_db($db_name);
$q_ws="select id, name, institute, country, accept from reg_stimm2 order by data asc" ;
$rq_ws=mysql_query($q_ws);
$i=1;
while($row_q_ws=mysql_fetch_row($rq_ws)){
if($row_q_ws[4]==0 && $row_q_ws[1]){
echo "
|
".stripslashes($row_q_ws[1])." |
| ".stripslashes($row_q_ws[2]).', '."".stripslashes($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, afil,prez_author,prez_src, pres_yn from ws_ro_07 order by date_reg asc" ;
$rq_ws=mysql_query($q_ws);
$i=1;
while($row_q_ws=mysql_fetch_row($rq_ws)){
if($row_q_ws[5]==0 && $row_q_ws[1]){
echo "";
$i=$i+1;
}
//$i=$i+1;
}
mysql_close($linkdb);
}
?>
Solar - Terrestrial Interactions from Microscale to Global Models