преброяване на общия брой.

[sentenello]

Здравейте,

Направо ще дам целия код , за да не има излишни питания относно кода.

$query = mysql_query("SELECT
cyn.divisionid AS divid,
 cyn.name AS liga,
 e.id as eventid,
 e.name AS divisiq 
 FROM `country` cyn 
 LEFT JOIN `event` e ON e.id = cyn.divisionid
 LEFT JOIN `match` m ON e.id = m.event_id
 WHERE m.start_date >= NOW()
 AND awayteam NOT REGEXP '^-?[0-9]+$'
  AND awayteam IS NOT NULL 
  AND TRIM(awayteam) <> ''
 group by e.name
 Order by cyn.name ASC
");
$events = array();
$rows = array();


// запазваме всичко
while($row = mysql_fetch_assoc($query))

{
    $events[] = $row['liga'];
    $rows[] = $row;
}
echo"<table>";
// всеки евент ни трябва само веднъж

$events = array_unique($events);
foreach($events as $event)
{
    echo "

	<tr style='border-top: 3px solid #FFA403;'>
		<td colspan='2' style='color:#FFFFFF;padding-left: 10px;padding-top: 5px;padding-bottom: 5px;background:url(http://futbolnizalozi.futbolniprognozi.eu/wp-content/themes/PressNow/images/widgettitle-bg.png) left top repeat-x;'>$event</td>
	</tr>
	";

    foreach($rows as $key => $val)

    {
	
	if($val['liga'] == $event)
        {
            unset($rows[$key]);
			
$query2 = mysql_query("SELECT count(event_id) as broi FROM `match`
WHERE event_id ='$val[divid]' AND start_date >= NOW() AND awayteam NOT REGEXP '^-?[0-9]+$'");
while($row2 = mysql_fetch_array($query2))
{

            echo"
	<tr class='upcoming';>
		<td style='padding-left: 15px;'> <a href='../?league=$event&division=$val[divisiq]'>$val[divisiq]</a></td>
		<td class='oddstyle'> ($row2[broi])</td>
	</tr>";
			

        }
		}

    }

}

Като цяло крайния резултат от тук изглежда така.

Англия
     Премиършип (5)
     Чемпиъншип (3)
Германия
     Първа бундеслига (4)

Въпроса ми е как да преброя колко са общо и примерно до Англия да изкарам (8)

 

[joTunkiq]

if($val['liga'] == $event)
        {
            unset($rows[$key]);
         
$query2 = mysql_query("SELECT count(event_id) as broi FROM `match`
WHERE event_id ='$val[divid]' AND start_date >= NOW() AND awayteam NOT REGEXP '^-?[0-9]+$'");
while($row2 = mysql_fetch_array($query2))
{

            echo"
   <tr class='upcoming';>
      <td style='padding-left: 15px;'> <a href='../?league=$event&division=$val[divisiq]'>$val[divisiq]</a></td>
      <td class='oddstyle'> ($row2[broi])</td>
   </tr>";
         
       $lastLigabroi+= $row2[broi];
        }
echo $lastLigabroi;

:idea: :?:

 

[raiden]

$query = mysql_query("SELECT
cyn.divisionid AS divid,
 cyn.name AS liga,
 e.id as eventid,
 e.name AS divisiq,
count(e.name) AS broi
 FROM `country` cyn
 LEFT JOIN `event` e ON e.id = cyn.divisionid
 LEFT JOIN `match` m ON e.id = m.event_id
 WHERE m.start_date >= NOW()
 AND awayteam NOT REGEXP '^-?[0-9]+$'
  AND awayteam IS NOT NULL
  AND TRIM(awayteam) <> ''
 group by e.name
 Order by cyn.name ASC
");

 

[sentenello]

$query = mysql_query("SELECT
cyn.divisionid AS divid,
 cyn.name AS liga,
 e.id as eventid,
 e.name AS divisiq,
count(e.name) AS broi
 FROM `country` cyn
 LEFT JOIN `event` e ON e.id = cyn.divisionid
 LEFT JOIN `match` m ON e.id = m.event_id
 WHERE m.start_date >= NOW()
 AND awayteam NOT REGEXP '^-?[0-9]+$'
  AND awayteam IS NOT NULL
  AND TRIM(awayteam) <> ''
 group by e.name
 Order by cyn.name ASC
");

За това се сетих, но после как да го изведа там където съм извел $event ?

 

[anonimen]

$query = mysql_query("SELECT
cyn.divisionid AS divid,
 cyn.name AS liga,
 e.id as eventid,
 e.name AS divisiq,
count(e.name) AS broi
 FROM `country` cyn
 LEFT JOIN `event` e ON e.id = cyn.divisionid
 LEFT JOIN `match` m ON e.id = m.event_id
 WHERE m.start_date >= NOW()
 AND awayteam NOT REGEXP '^-?[0-9]+$'
  AND awayteam IS NOT NULL
  AND TRIM(awayteam) <> ''
 group by e.name
 Order by cyn.name ASC
");

За това се сетих, но после как да го изведа там където съм извел $event ?

echo $row_array['broj'];
echo $row_object->broj;
echo $row_array[$пореден_номер_на_колоната]

:!: