Limit van 5 laten zien

Status
Niet open voor verdere reacties.

TrainerEW

Gebruiker
Lid geworden
7 jan 2008
Berichten
9
Hallo wij willen wie de meeste homegoals heeft gemaakt boven aan komt te staan dit lukt ook maar als wij een limit geven van 5 dan gaat het mis (ORDER BY name LIMIT 5)

hoe kunnen we dit oplossen kijk op http://trainerew.nl/svhalle/
en zie man of te match nu staat wie de meest goals heeft niet boven aan en als we de limit weg halen wel maar dan komen ze allemaal te staan dat willen we net niet

PHP:
<?php
include('cms/manofthematch_stand/user.php');
$connection = mysql_connect("$host","$user","$password")
or die(mysql_error());
mysql_select_db("$txt_db_name",$connection)
or die(mysql_error());

$pref = mysql_query("SELECT * FROM tplls_preferences WHERE ID = '1'",$connection)
or die(mysql_error());
$pdata = mysql_fetch_array($pref);
mysql_free_result($pref);

$team_name = $pdata['teamname'];
$d_seasonid = $pdata['defaultseasonid'];
$show_all_or_one = $pdata['defaultshow'];
$show_table = $pdata['defaulttable'];
$language = $pdata['defaultlanguage'];
$for_win = $pdata['forwin'];
$for_draw = $pdata['fordraw'];
$for_lose = $pdata['forloss'];
$print_date = $pdata['printdate'];
$top_bg = $pdata['topoftable'];
$bg1 = $pdata['bg1'];
$bg2 = $pdata['bg2'];
$inside_c = $pdata['inside'];
$border_c = $pdata['bordercolour'];
$tb_width = $pdata['tablewidth'];
$accept_ml = $pdata['acceptmultilanguage'];

$updated_query = mysql_query("
SELECT DATE_FORMAT(last_updated, '%d.%m.%Y at %H:%i') AS last_updated FROM tplls_preferences WHERE ID = '1'", $connection)
or die(mysql_error());
$ludata = mysql_fetch_array($updated_query);
$last_update = $ludata['last_updated'];
mysql_free_result($updated_query);

if(!session_is_registered('defaultlanguage') || !session_is_registered('defaultseasonid') || !session_is_registered('defaultshow') || !session_is_registered('defaulttable'))
{
	$_SESSION['defaultlanguage'] = $language;
	$_SESSION['defaultseasonid'] = $d_seasonid;
	$_SESSION['defaultshow'] = $show_all_or_one;
	$_SESSION['defaulttable'] = $show_table;
	$defaultlanguage = $_SESSION['defaultlanguage'];
	$defaultseasonid = $_SESSION['defaultseasonid'];
	$defaultshow = $_SESSION['defaultshow'];
	$defaulttable = $_SESSION['defaulttable'];
}
else
{
	$defaultlanguage = $_SESSION['defaultlanguage'];
	$defaultseasonid = $_SESSION['defaultseasonid'];
	$defaultshow = $_SESSION['defaultshow'];
	$defaulttable = $_SESSION['defaulttable'];
}

$get_seasons = mysql_query("SELECT * FROM tplls_seasonnames WHERE SeasonPublish = '1' ORDER BY SeasonName",$connection)
or die(mysql_error());

$sort = $_REQUEST['sort'];
if(!isset($sort))
{
	$sort = 'tf';
}
?>
<?php

if($defaultshow == 1)
{
}
elseif($defaultshow == 2)
{
}
elseif($defaultshow == 3)
{
}

if($defaultseasonid == 0)
	$defaultseasonid = '%';

?>
<table align="center" width="100%" cellspacing="0" cellpadding="0" border="0" bgcolor="<?php echo $border_c ?>">
<tr>
<td>

	<table width="100%" cellspacing="1" cellpadding="5" border="0">
	<tr>
	<td bgcolor="<?php echo $inside_c ?>" align="left">
		<?php

		if($defaulttable == 1 || $defaulttable == 3)
		{
		?>
		<table width="100%" cellspacing="1" cellpadding="2" border="0">
		</tr>
		<tr>

		<td align="left" valign="middle" bgcolor="<?php echo $top_bg ?>">
		<b><?= $lng_position_short ?></b>
		</td>

		<td align="left" valign="middle" bgcolor="<?php echo $top_bg ?>">
		<b><?= $lng_team ?></b>
		</td>

		</tr>

		<?php
		}
		elseif($defaulttable == 4)
		{
		?>
		<table width="100%" cellspacing="1" cellpadding="2" border="0">

		<tr>

		<td align="left" valign="middle" bgcolor="<?php echo $top_bg ?>">
		</td>

		<td align="left" valign="middle" bgcolor="<?php echo $top_bg ?>">
		<b>Naam</b>
		</td>

  		<td align="center" valign="middle" bgcolor="<?php echo $top_bg ?>">
		<b>Punten</b>
        
   		<td align="center" valign="middle" bgcolor="<?php echo $top_bg ?>">
		</td>
		</tr>
		<?php
		}
		?>

		<?php

		$get_teams = mysql_query("
		SELECT DISTINCT
		O.OpponentName AS name,
		O.OpponentID AS id
		FROM tplls_opponents O, tplls_leaguematches LM
		WHERE LM.LeagueMatchSeasonID LIKE '$defaultseasonid' AND
		(O.OpponentID = LM.LeagueMatchHomeID OR
		O.OpponentID = LM.LeagueMatchAwayID)
		ORDER BY name limit 5
		", $connection)
		or die(mysql_error());

		$i = 0;
		while($data = mysql_fetch_array($get_teams))
		{
			$team[$i] = $data['name'];
			$teamid[$i] = $data['id'];


			if($defaulttable == 1 || $defaulttable == 2 || $defaulttable == 4)
			{

				$query = mysql_query("
				SELECT
				COUNT(DISTINCT LM.LeagueMatchID) AS homewins
				FROM
				tplls_leaguematches LM
				WHERE
				LM.LeagueMatchHomeWinnerID = '$teamid[$i]' AND
				LM.LeagueMatchSeasonID LIKE '$defaultseasonid'
				", $connection)
				or die(mysql_error());


				$mdata = mysql_fetch_array($query);
				$homewins[$i] = $mdata['homewins'];

				mysql_free_result($query);

				$query = mysql_query("
				SELECT
				COUNT(DISTINCT LM.LeagueMatchID) AS homedraws
				FROM
				tplls_leaguematches LM
				WHERE
				LM.LeagueMatchHomeTieID = '$teamid[$i]' AND
				LM.LeagueMatchSeasonID LIKE '$defaultseasonid'
				", $connection)
				or die(mysql_error());


				$mdata = mysql_fetch_array($query);
				$homedraws[$i] = $mdata['homedraws'];

				mysql_free_result($query);

				$query = mysql_query("
				SELECT
				COUNT(DISTINCT LM.LeagueMatchID) AS homeloses
				FROM
				tplls_leaguematches LM
				WHERE
				LM.LeagueMatchHomeLoserID = '$teamid[$i]' AND
				LM.LeagueMatchSeasonID LIKE '$defaultseasonid'
				", $connection)
				or die(mysql_error());

				$mdata = mysql_fetch_array($query);
				$homeloses[$i] = $mdata['homeloses'];

				mysql_free_result($query);


				$query = mysql_query("
				SELECT
				COUNT(DISTINCT LM.LeagueMatchID) AS awaywins
				FROM
				tplls_leaguematches LM
				WHERE
				LM.LeagueMatchAwayWinnerID = '$teamid[$i]' AND
				LM.LeagueMatchSeasonID LIKE '$defaultseasonid'
				", $connection)
				or die(mysql_error());

			
				$mdata = mysql_fetch_array($query);
				$awaywins[$i] = $mdata['awaywins'];

				mysql_free_result($query);

				$query = mysql_query("
				SELECT
				COUNT(DISTINCT LM.LeagueMatchID) AS awaydraws
				FROM
				tplls_leaguematches LM
				WHERE
				LM.LeagueMatchAwayTieID = '$teamid[$i]' AND
				LM.LeagueMatchSeasonID LIKE '$defaultseasonid'
				", $connection)
				or die(mysql_error());

		
				$mdata = mysql_fetch_array($query);
				$awaydraws[$i] = $mdata['awaydraws'];

				mysql_free_result($query);

				$query = mysql_query("
				SELECT
				COUNT(DISTINCT LM.LeagueMatchID) AS awayloses
				FROM
				tplls_leaguematches LM
				WHERE
				LM.LeagueMatchAwayLoserID = '$teamid[$i]' AND
				LM.LeagueMatchSeasonID LIKE '$defaultseasonid'
				", $connection)
				or die(mysql_error());

				$mdata = mysql_fetch_array($query);
				$awayloses[$i] = $mdata['awayloses'];

				mysql_free_result($query);

				$query = mysql_query("
				SELECT
				SUM( LM.LeagueMatchHomeGoals) AS homegoals
				FROM
				tplls_leaguematches LM
				WHERE
				LM.LeagueMatchHomeID = '$teamid[$i]' AND
				LM.LeagueMatchSeasonID LIKE '$defaultseasonid'
				", $connection)
				or die(mysql_error());

				$mdata = mysql_fetch_array($query);
				if(is_null($mdata['homegoals']))
					$homegoals[$i] = 0;
				else
					$homegoals[$i] = $mdata['homegoals'];

				mysql_free_result($query);

				$query = mysql_query("
				SELECT
				SUM( LM.LeagueMatchAwayGoals) AS homegoalsagainst
				FROM
				tplls_leaguematches LM
				WHERE
				LM.LeagueMatchHomeID = '$teamid[$i]' AND
				LM.LeagueMatchSeasonID LIKE '$defaultseasonid'
				", $connection)
				or die(mysql_error());

				$mdata = mysql_fetch_array($query);
				if(is_null($mdata['homegoalsagainst']))
					$homegoalsagainst[$i] = 0;
				else
					$homegoalsagainst[$i] = $mdata['homegoalsagainst'];

				mysql_free_result($query);


				$query = mysql_query("
				SELECT
				SUM( LM.LeagueMatchAwayGoals) AS awaygoals
				FROM
				tplls_leaguematches LM
				WHERE
				LM.LeagueMatchAwayID = '$teamid[$i]' AND
				LM.LeagueMatchSeasonID LIKE '$defaultseasonid'
				", $connection)
				or die(mysql_error());

				$mdata = mysql_fetch_array($query);
				if(is_null($mdata['awaygoals']))
					$awaygoals[$i] = 0;
				else
					$awaygoals[$i] = $mdata['awaygoals'];

				mysql_free_result($query);

				$query = mysql_query("
				SELECT
				SUM( LM.LeagueMatchHomeGoals) AS awaygoalsagainst
				FROM
				tplls_leaguematches LM
				WHERE
				LM.LeagueMatchAwayID = '$teamid[$i]' AND
				LM.LeagueMatchSeasonID LIKE '$defaultseasonid'
				", $connection)
				or die(mysql_error());

				$mdata = mysql_fetch_array($query);
				if(is_null($mdata['awaygoalsagainst']))
					$awaygoalsagainst[$i] = 0;
				else
					$awaygoalsagainst[$i] = $mdata['awaygoalsagainst'];

				mysql_free_result($query);
			}
			elseif($defaulttable == 3)
			{
				$homewins[$i] = 0;
				$homedraws[$i] = 0;
				$homeloses[$i] = 0;
				$awaywins[$i] = 0;
				$awaydraws[$i] = 0;
				$awayloses[$i] = 0;
				$homegoals[$i] = 0;
				$homegoalsagainst[$i] = 0;
				$awaygoals[$i] = 0;
				$awaygoalsagainst[$i] = 0;

				$query = mysql_query("
				SELECT
				LM.LeagueMatchHomeID AS homeid,
				LM.LeagueMatchAwayID AS awayid,
				LM.LeagueMatchHomewinnerID AS homewinner,
				LM.LeagueMatchHomeLoserID AS homeloser,
				LM.LeagueMatchAwayWinnerID AS awaywinner,
				LM.LeagueMatchAwayLoserID AS awayloser,
				LM.LeagueMatchHomeTieID AS hometie,
				LM.LeagueMatchAwayTieID AS awaytie,
				LM.LeagueMatchHomeGoals AS homegoals,
				LM.LeagueMatchAwayGoals AS awaygoals
				FROM
				tplls_leaguematches LM
				WHERE
				(LM.LeagueMatchHomeWinnerID = '$teamid[$i]' OR
				LM.LeagueMatchHomeLoserID = '$teamid[$i]' OR
				LM.LeagueMatchAwayWinnerID = '$teamid[$i]' OR
				LM.LeagueMatchAwayLoserID = '$teamid[$i]' OR
				LM.LeagueMatchHomeTieID = '$teamid[$i]' OR
				LM.LeagueMatchAwayTieID = '$teamid[$i]') AND
				LM.LeagueMatchSeasonID LIKE '$defaultseasonid'
				ORDER BY LM.LeagueMatchDate DESC
				LIMIT 6
				", $connection)
				or die(mysql_error());

				while($row = mysql_fetch_array($query))
				{
					if(is_null($row['homegoals']))
						$row['homegoals'] = 0;

					if(is_null($row['awaygoals']))
						$row['awaygoals'] = 0;


					if($row['homewinner'] == $teamid[$i])
					{
						$homewins[$i]++;
					}
					elseif($row['homeloser'] == $teamid[$i])
					{
						$homeloses[$i]++;
					}
					elseif($row['hometie'] == $teamid[$i])
					{
						$homedraws[$i]++;
					}
					elseif($row['awaywinner'] == $teamid[$i])
					{
						$awaywins[$i]++;
					}
					elseif($row['awayloser'] == $teamid[$i])
					{
						$awayloses[$i]++;
					}
					elseif($row['awaytie'] == $teamid[$i])
					{
						$awaydraws[$i]++;
					}


					if($row['homeid'] == $teamid[$i])
					{
						$homegoals[$i] = $homegoals[$i] + $row['homegoals'];
						$homegoalsagainst[$i] = $homegoalsagainst[$i] + $row['awaygoals'];
					}
					else
					{
						$awaygoals[$i] = $awaygoals[$i] + $row['awaygoals'];
						$awaygoalsagainst[$i] = $awaygoalsagainst[$i] + $row['homegoals'];
					}



				}

				mysql_free_result($query);

			}

			if($defaulttable == 1 || $defaulttable == 3 || $defaulttable == 4)
			{

				$wins[$i] = ($homewins[$i]+$awaywins[$i]);
				$draws[$i] = ($homedraws[$i]+$awaydraws[$i]);
				$loses[$i] = ($homeloses[$i]+$awayloses[$i]);
				$goals_for[$i] = ($homegoals[$i] + $awaygoals[$i]);
				$goals_against[$i] = ($homegoalsagainst[$i] + $awaygoalsagainst[$i]);

				if($defaulttable == 1 || $defaulttable == 4)
				{
					$get_deduct = mysql_query("
					SELECT points
					FROM tplls_deductedpoints
					WHERE seasonid LIKE '$defaultseasonid' AND
					teamid = '$teamid[$i]'
					LIMIT 1
					", $connection)
					or die(mysql_error());

					$temp_points = 0;

					if(mysql_num_rows($get_deduct) > 0)
					{
						while($d_points = mysql_fetch_array($get_deduct))
						{
							$temp_points = $temp_points + $d_points['points'];
						}
					}

					mysql_free_result($get_deduct);
				}
				else
				{
					$temp_points = 0;
				}

				$points[$i] = $temp_points + (($homewins[$i]+$awaywins[$i])*$for_win) + (($homedraws[$i]+$awaydraws[$i])*$for_draw) + (($homeloses[$i]+$awayloses[$i])*$for_lose);
				$pld[$i] = $homewins[$i]+$homedraws[$i]+$homeloses[$i]+$awaywins[$i]+$awaydraws[$i]+$awayloses[$i];

				$diff[$i] = ($homegoals[$i] + $awaygoals[$i]) - ($homegoalsagainst[$i] + $awaygoalsagainst[$i]);

			}
			elseif($defaulttable == 2)
			{
				$wins[$i] = ($homewins[$i]+$awaywins[$i]);
				$draws[$i] = ($homedraws[$i]+$awaydraws[$i]);
				$loses[$i] = ($homeloses[$i]+$awayloses[$i]);
				$goals_for[$i] = ($homegoals[$i] + $awaygoals[$i]);
				$goals_against[$i] = ($homegoalsagainst[$i] + $awaygoalsagainst[$i]);

				$get_deduct = mysql_query("
				SELECT points
				FROM tplls_deductedpoints
				WHERE seasonid LIKE '$defaultseasonid' AND
				teamid = '$teamid[$i]'
				LIMIT 1
				", $connection)
				or die(mysql_error());

				$temp_points = 0;

				if(mysql_num_rows($get_deduct) > 0)
				{
					while($d_points = mysql_fetch_array($get_deduct))
					{
						$temp_points = $temp_points + $d_points['points'];
					}
				}

				mysql_free_result($get_deduct);

				$points[$i] = $temp_points + (($homewins[$i]+$awaywins[$i])*$for_win) + (($homedraws[$i]+$awaydraws[$i])*$for_draw) + (($homeloses[$i]+$awayloses[$i])*$for_lose);
				$pld[$i] = $homewins[$i]+$homedraws[$i]+$homeloses[$i]+$awaywins[$i]+$awaydraws[$i]+$awayloses[$i];

				if($pld[$i] != 0)
				{
					$win_pros[$i] = round(100*($wins[$i]/$pld[$i]), 2);
					$draw_pros[$i] = round(100*($draws[$i]/$pld[$i]), 2);
					$loss_pros[$i] = round(100*($loses[$i]/$pld[$i]), 2);

					$av_points[$i] = round($points[$i]/$pld[$i], 2);

					$av_for[$i] = round($goals_for[$i]/$pld[$i], 2);
					$av_against[$i] = round($goals_against[$i]/$pld[$i], 2);
				}
				else
				{
					$win_pros[$i] = 0;
					$draw_pros[$i] = 0;
					$loss_pros[$i] = 0;

					$av_points[$i] = 0;

					$av_for[$i] = 0;
					$av_against[$i] = 0;
				}

				$av_diff[$i] = $av_for[$i] - $av_against[$i];

			}

			$i++;
		}

		$qty = mysql_num_rows($get_teams);

		mysql_free_result($get_teams);


		if($defaulttable == 1 || $defaulttable == 3 || $defaulttable == 4)
		{


			switch($sort)
			{
				case 'tf':
				array_multisort($goals_for, SORT_DESC, SORT_NUMERIC, $points, SORT_DESC, SORT_NUMERIC, $diff, SORT_DESC, SORT_NUMERIC, $wins, SORT_DESC, SORT_NUMERIC, $goals_against, SORT_ASC, SORT_NUMERIC, $draws, $loses, $pld, SORT_DESC, SORT_NUMERIC, $team, $homewins, $homedraws, $homeloses, $awaywins, $awaydraws, $awayloses, $homegoals, $homegoalsagainst, $awaygoals, $awaygoalsagainst);
				break;

			}

			if($defaulttable == 1 || $defaulttable == 3)
			{

				$j=1;
				$i=0;
				while($i< $qty)
				{
					if(isset($draw_line))
					{

						for($k = 0 ; $k < sizeof($draw_line) ; $k++)
						{
							if($draw_line[$k] == $i)
							{
								$templine_width = $tb_width-20;
								echo"
								<tr>
								<td height=\"5\" colspan=\"20\" align=\"center\" valign=\"middle\">
								<img src=\"images/line.gif\" width=\"$templine_width\" height=\"5\" ALT=\"\"><br>
								</td>
								</tr>
								";
							}
						}
					}


					echo"
					<tr>

					<td align=\"center\" valign=\"middle\" bgcolor=\"$tf\">";

					if($sort == 'tf')
						echo'<b>';

					echo"$goals_for[$i]";

					if($sort == 'tf')
						echo'</b>';


					$i++;
					$j++;
				}
			}
			elseif($defaulttable == 4)
			{
				$j=1;
				$i=0;

				while($i< $qty)
				{
					if(isset($draw_line))
					{
						for($k = 0 ; $k < sizeof($draw_line) ; $k++)
						{
							if($draw_line[$k] == $i)
							{
								$templine_width = $tb_width-20;
								echo"
								<tr>
								<td height=\"5\" colspan=\"20\" align=\"center\" valign=\"middle\">
								<img src=\"images/line.gif\" width=\"$templine_width\" height=\"5\" ALT=\"\"><br>
								</td>
								</tr>
								";
							}
						}
					}


					echo"
					<tr>

					<td align=\"left\" width=\"1\" valign=\"middle\" bgcolor=\"$bg1\">
					$j.
					</td>

					<td align=\"left\" width=\"120\" valign=\"middle\" bgcolor=\"$bg1\">
					$team[$i]
					</td>";

					echo"

					<td align=\"center\" width=\"100\" valign=\"middle\" bgcolor=\"$bg1\">";

					echo "<b>"; echo"$goals_for[$i]"; echo "</b>";

					if($sort == 'tf')
						echo'</b>';
					echo"</td>
					</tr>
					";

					$i++;
					$j++;
				}
			}
		}
		elseif($defaulttable == 2)
		{


			$j=1;
			$i=0;
			while($i< $qty)


				$i++;
				$j++;
			}

		?>

		</table>
	</td>
	</tr>
	</table>
</td>
</tr>
</table>
 
Laatst bewerkt door een moderator:
Tip: Gebruik PHP tags

Stukje aangenamer om te lezen.

K'denk dat je moet zetten LIMIT 0,5
 
Laatst bewerkt:
Dat heb je niet, ik had net je bericht aangepast zodat er
PHP:
{je_code}
stond.

Nu heb jij dat weer teruggedraaid naar QUOTE-tags :confused:

Ik pas hem nu nog 1x aan.
 
Oke bedankt

Dat heb je niet, ik had net je bericht aangepast zodat er
PHP:
{je_code}
stond.

Nu heb jij dat weer teruggedraaid naar QUOTE-tags :confused:

Ik pas hem nu nog 1x aan.


maar weet je ook hoe wij dit kunnen oplossen:thumb:
 
Als jij
[sql]
(ORDER BY name LIMIT 5)
[/sql]
werkt het inderdaad niet. Je sorteert dan op de naam (ORDER BY NAME).

ik neem aan da het gaat om deze query
[sql]
SELECT
SUM( LM.LeagueMatchHomeGoals) AS homegoals
FROM
tplls_leaguematches LM
WHERE
LM.LeagueMatchHomeID = '$teamid[$i]' AND
LM.LeagueMatchSeasonID LIKE '$defaultseasonid'
[/sql]

Als je een SUM hebt moet er ergens op gegroepeerd worden. Maw de opgetelde waarde moet ergens bij horen. In dit geval het team denk ik. Je moet er een
GROUP BY team
ORDER BY homegoals DESC
LIMIT 5

Dit zou naar mijn idee moeten werken. bij team moet je ff het veldnaam van het team gebruiken uiteraard.

succes
 
Als jij
[sql]
(ORDER BY name LIMIT 5)
[/sql]
werkt het inderdaad niet. Je sorteert dan op de naam (ORDER BY NAME).

ik neem aan da het gaat om deze query
[sql]
SELECT
SUM( LM.LeagueMatchHomeGoals) AS homegoals
FROM
tplls_leaguematches LM
WHERE
LM.LeagueMatchHomeID = '$teamid[$i]' AND
LM.LeagueMatchSeasonID LIKE '$defaultseasonid'
[/sql]

Als je een SUM hebt moet er ergens op gegroepeerd worden. Maw de opgetelde waarde moet ergens bij horen. In dit geval het team denk ik. Je moet er een
GROUP BY team
ORDER BY homegoals DESC
LIMIT 5

Dit zou naar mijn idee moeten werken. bij team moet je ff het veldnaam van het team gebruiken uiteraard.

succes

Ik heb het er nu zo neergezet:
SELECT
SUM( LM.LeagueMatchHomeGoals) AS homegoals
FROM
tplls_leaguematches LM
WHERE
LM.LeagueMatchHomeID = '$teamid[$i]' AND
LM.LeagueMatchSeasonID LIKE '$defaultseasonid'
GROUP BY 'Ard Burghardt' ORDER BY homegoals DESC LIMIT 5

Maar er gebeurt niet veel. Ik doe volgens mij heel wat verkeerd.
 
Code:
 $result = mysql_query("select * from infopagina  totaal ORDER BY $bezoekers DESC Limit $limiet ",$db);

Dit is wat ik heb en wat werkt. :thumb:

Je moet aangeven of hij omhoog of omlaag moet sorteren.
ASC of DESC.
 
Ik heb het er nu zo neergezet:
SELECT
SUM( LM.LeagueMatchHomeGoals) AS homegoals
FROM
tplls_leaguematches LM
WHERE
LM.LeagueMatchHomeID = '$teamid[$i]' AND
LM.LeagueMatchSeasonID LIKE '$defaultseasonid'
GROUP BY 'Ard Burghardt' ORDER BY homegoals DESC LIMIT 5

Maar er gebeurt niet veel. Ik doe volgens mij heel wat verkeerd.

Je kunt niet groeperen op een waarde in een tabel.
GROUP BY 'Ard Burghardt' kan dus niet. Je moet groeperen op de naam van het veld, dus op team id oid. Als je dan alleen de velden wilt laten zien van 'Ard Burghardt' moet je dit opnemen in de WHERE clause. bijv:
[sql]
WHERE
LM.LeagueMatchHomeID = '$teamid[$i]' AND
LM.LeagueMatchSeasonID LIKE '$defaultseasonid' AND
naamveld LIKE 'Ard Burghardt'
[/sql]

Als je de databasestructuur laat zien en precies aangeeft wat je wil zien dan kan ik de query wel voor je opzetten.
 
Laatst bewerkt:
Je kunt niet groeperen op een waarde in een tabel.
GROUP BY 'Ard Burghardt' kan dus niet. Je moet groeperen op de naam van het veld, dus op team id oid. Als je dan alleen de velden wilt laten zien van 'Ard Burghardt' moet je dit opnemen in de WHERE clause. bijv:
[sql]
WHERE
LM.LeagueMatchHomeID = '$teamid[$i]' AND
LM.LeagueMatchSeasonID LIKE '$defaultseasonid' AND
naamveld LIKE 'Ard Burghardt'
[/sql]

Als je de databasestructuur laat zien en precies aangeeft wat je wil zien dan kan ik de query wel voor je opzetten.

Dit is onze datastructuur:

database.png
 
Help

Wie kan dit voor ons oplossen wij komen er zelf niet uit wie kan deze uitdaging aan :thumb:
 
Als je niet op mijn mogelijke oplossing reageert, wat heeft dan nog voor nut om hier nog meer oplossingen neer te zetten ? :confused:
 
Status
Niet open voor verdere reacties.
Terug
Bovenaan Onderaan