$sqlCombination = "
SELECT person.*, horse.*, 2010Combination.*
FROM FEIPerson AS person
INNER JOIN 2010Combination ON person.fei_id = 2010Combination.personFEIid
INNER JOIN FEIHorse horse ON horse.fei_id = 2010Combination.horseFEIid
WHERE 2010Combination.is_nc = 'No'
AND 2010Combination.is_waitingList = 'No'
ORDER BY person.competing_for_country, horse.complete_name ASC";Nu moet er in de tabel 2010Combination iets aangepast worden in de volgorde zoals hierboven is aangegeven bij ORDER.
Dit probeer als volgt maar het werkt niet.
<?php
while ($x < $numbercombination)
{
$combinationID = mysql_result($resultcombination,$x,"combinationID");
echo "Counter = ".$x." - CompNo = ".$CompNo." - combinationID = ".$combinationID."<BR>";
$combinationLocked=mysql_result($resultcombination,$x,"combinationLocked");
if($combinationLocked == "No")
{
$sqlCombUpdate = "
UPDATE 2010Combination
SET compNumber ='".$CompNo."' ,combinationLocked='Yes'
WHERE combinationID= '".$combinationID."'
ORDER BY person.competing_for_country, horse.complete_name ASC";
// echo $sqlCombUpdate."<BR>";
$resultcombupdate = MYSQL_QUERY($sqlCombUpdate) or die('Number UPDATE Combination Query failed: ' . mysql_error());
$CompNo++;
}
$x++;
}// end while
?>Een idee wat ik fout doe?
