I'm using two Queries and want to output $ form both.
I'm using a while statement for the second query, how can I define a variable in this While loop which uses a $ form the first query where `sc` and `naam`(query 2) must match.
Tried this, but doesn't work.
First query:
Code: Select all
<?php
$deelname = "SELECT DISTINCT COUNT(`inschrijving`.`WedstrijdId`) AS `visited`, `deelnemer`.`Naam` AS `sc` FROM `deelnemer` INNER JOIN `inschrijving` ON (`deelnemer`.`Id` = `inschrijving`.`DeelnemerId`) INNER JOIN `wedstrijd` ON (`inschrijving`.`WedstrijdId` = `wedstrijd`.`Id`)GROUP BY `deelnemer`.`Naam` ";
$aantal = mysql_query($deelname) or die("Error: " . mysql_error());
while ($line2 = mysql_fetch_array($aantal, MYSQL_ASSOC)){
$Visit = $line2["visited"];
$sc = $line2["sc"];
}
?>Code: Select all
<?php
$query = "SELECT `klasse`.`Klasse` AS `Klasse`,`klassement`.`LevelId` AS `Level`,`deelnemer`.`Naam` AS `naam`,`deelnemer`.`Vereniging` AS `Vereniging`, `deelnemer`.`URL` AS `URL`, TRUNCATE (`klassement`.`Totaal percentage` * 100, 2) AS `Totaal%`, TRUNCATE (`klassement`.`Gemiddelde percentage` * 100,2) AS `Gem%` FROM `klassement` INNER JOIN `deelnemer` ON (`klassement`.`DeelnemerId` = `deelnemer`.`Id`) INNER JOIN `deelnemerklasselevel` ON (`deelnemer`.`Id` = `deelnemerklasselevel`.`DeelnemerId`) INNER JOIN `klasse` ON (`klassement`.`KlassId` = `klasse`.`Id`) GROUP BY `Klasse`,`Naam`,`Level` ORDER BY `Klasse`,`Level`,`Totaal Percentage` DESC LIMIT $limitvalue, $limit";
$result = mysql_query($query) or die("Error: " . mysql_error());
$numrows = mysql_num_rows($result);
if($numrows == 0){
echo("Nothing to Display!");
}
?>While statement
Code: Select all
<?php
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
$row_count = $row_count;
$Klasse = $line["Klasse"];
$Level = $line["Level"];
$Naam = $line["naam"];
$Vereniging = $line["Vereniging"];
$Totaal = $line["Totaal%"];
$Gem = $line["Gem%"];
$URL = $line["URL"];
if ($sc == $Naam) {
$Visit = $line2["visited"];
}
?>