Турниры
connectdatabase($host,$db,$user, $pass);
$sql="
SELECT *
FROM online_turnir_group
";
$result=mysql_query($sql);
while($row=mysql_fetch_array($result))
{
$id=$row["id"];
$id_1=$id-1;
$turnirs=$row["turnirs"];
$turnir_name=$row["turnir_name"];
$turnir_logo=$row["turnir_logo"];
$turnirs_id[$id_1]=$turnirs;
echo ''.$turnir_name.' '; $sql_t=" SELECT DISTINCT translation FROM online_turnir WHERE turnir_id IN (".$turnirs.") "; $result_t=mysql_query($sql_t); while($row_t=mysql_fetch_array($result_t)) { $tr=$row_t["translation"]; echo ' '.$tr.' '; } } ?> |