Aliĝintoj

Jam aliĝis:<?php
$sql = 'SELECT count(`sid`) AS count FROM `webform_submissions` where nid = 3';
$usqqq = db_fetch_object(db_query($sql));
print $usqqq->count; ?>.<br>
<a href='http://www.ural-sib.org/eo/content/aligxilo'>Aliĝu ankaŭ vi!</a>
<hr>
<?php
// *** Esprimo - 4 ***
//$sql1 = \'SELECT sid, data FROM `webform_submitted_data` where cid=1172048979 or cid=1172050817 order by sid\';
//$sql2 = \'SELECT sid, data FROM `webform_submitted_data` where cid=1172049028 or cid=1172050756 order by sid\';
//$sql3 = \'SELECT sid, data FROM `webform_submitted_data` where cid=1172049459 or cid=1172051215 order by sid\';
//$sql4 = \'SELECT sid, data FROM `webform_submitted_data` where cid=1172049376 or cid=1172051079 order by sid\'; //tel.
//$sql5 = \'SELECT sid, data FROM `webform_submitted_data` where cid=1176107478 or cid=1176113208 order by sid\'; //patronomo

// *** Esprimo - 5 ***
//$sql1 = \'SELECT sid, data FROM `webform_submitted_data` where cid=3 and nid=69 order by sid\';
//$sql2 = \'SELECT sid, data FROM `webform_submitted_data` where cid=1 and nid=69 order by sid\';
//$sql3 = \'SELECT sid, data FROM `webform_submitted_data` where cid=13 and nid=69 order by sid\';
//$sql4 = \'SELECT sid, data FROM `webform_submitted_data` where cid=20 and nid=69 order by sid\';

// *** Esprimo - 6 ***
$sql1 = 'SELECT sid, data FROM `webform_submitted_data` where cid=3 and nid=3 order by sid'; //nomo
$sql2 = 'SELECT sid, data FROM `webform_submitted_data` where cid=1 and nid=3 order by sid'; //famili
$sql3 = 'SELECT sid, data FROM `webform_submitted_data` where cid=14 and nid=3 order by sid'; //urbo

$result1 = db_query($sql1);
$result2 = db_query($sql2);
$result3 = db_query($sql3);

//$cnt = mysql_num_rows($result1);
$i = 1;

// *** Esprimo - 5 ***
//$logx_sen=0;
//$logx_2lit=0;
//$logx_10lit=0;

while ($row1 = db_fetch_array($result1)) {
$row2 = db_fetch_array($result2);
$row3 = db_fetch_array($result3);

// *** Esprimo - 5 ***
//(strpos($row4[\'data\'],\'sen\')===0)? $logx_sen++ : $logx_sen ;
//(strpos($row4[\'data\'],\'en 2\')===0)? $logx_2lit++ : $logx_2lit ;
//(strpos($row4[\'data\'],\'en 7\')===0)? $logx_10lit++ : $logx_10lit ;

printf("%d. %s %s (%s)<br>", $i++,
$row1['data'],
$row2['data'],
$row3['data']);
};

// *** Esprimo - 5 ***
//(strpos($row4[\'data\'],\'sen\')===0)?\'[hidden]<b>[/hidden]\':\'\',
//(strpos($row4[\'data\'],\'sen\')===0)?\'[hidden]</b>[/hidden]\':\'\');
//print (\"[hidden]<hr>\");
//print (\"<b>Sen logado: $logx_sen </b><br>\");
//print (\"2-litaj logado: $logx_2lit <br>\");
//print (\"7-10-litaj logado: $logx_10lit [/hidden]\");
?>

Urboj: 

EsPrimo: 

Komentoj el VKontakte