Why won't this sorting work?

[XploreR]

Hi. I have problems sorting. Can anyone help me? My output is correct just that the sorting dosen't work, which i want it to be in alphabetical order by the name of Game (column - Game). I'm using this with PHPLib Template and PHPLib dB class

Code:


$tables = array("PlaystationAction", "PlaystationAdventure", "PlaystationFighting", "PlaystationPlatform", "PlaystationPuzzle", "PlaystationRacing", "PlaystationRpg", "PlaystationSimulation", "PlaystationSports", "PlaystationStrategy");

foreach ($tables AS $table) {

$sql = "SELECT Alpha, Game, Url, Date, Publisher, Developer FROM $table
WHERE Alpha='a' ORDER BY Game ASC";

$db->query($sql);

while ($db->next_record()) {

$Alpha = $db->f(Alpha);
$Game = $db->f(Game);
$Url = $db->f(Url);
$Date = $db->f(Date);
$Publisher = $db->f(Publisher);
$Developer = $db->f(Developer);

$color = ($i++ % 2 ) ? '#000000' : '#333333';

$tmp3 = "<tr bgcolor='$color'><td><a href='/$Alpha/$Url/index.phtml'>$Game</a></td><td>$Publisher</td><td>$Developer</td><td>$Date</td></tr>";
$t->set_var('data', $tmp3);
$t->parse('DBlock', 'DataBlock', true);
}

}

[7stud]

Hi,

It looks to me like it is sorting each table alphabetically, but since you are outputing more than one table, it starts sorting again for the next table. Is that what the problem is?

[Anarchos]

The problem with this is your database design. What you should have done is made one table for all of the games, with an additional field called typeId, which links to a table called gameTypes with fields id and name.

[XploreR]

Hi 7stud ,

yes, that's exactly my problem. Any Help? Someone told me to use left join tho.

[7stud]

Hi,

There is no easy way to do that. You are going to have to read everything into an array and then sort the array.

[XploreR]

Does anyone know how? Please help

[petesmc]

while ($db->next_record()) {

$array[] = ('$Alpha => $db->f(Alpha)',
'$Game => $db->f(Game)',
'$Url => $db->f(Url)',
'$Date => $db->f(Date)',
'$Publisher => $db->f(Publisher)',
'$Developer => $db->f(Developer)');

}



Thats how you get it into an array, although I'm not sure how to sort it depending on a field of choice. You can use asort() or array_mutlisort but I don't know which.

[petesmc]

If this helps, I found this code on php.net for you:

function cmp ($a, $b) {
return strcmp($a["fruit"],$b["fruit"]);
}

$fruits[0]["fruit"] = "lemons";
$fruits[1]["fruit"] = "apples";
$fruits[2]["fruit"] = "grapes";

usort($fruits, "cmp");

while (list ($key, $value) = each ($fruits)) {
echo "\$fruits[$key]: " . $value["fruit"] . "\n";
}


That would print out
0: Apples
1: Lemonds
2: Grapes

[XploreR]

Thanks, petesmc

I'll have a go and let u know