Sorter i mysql og php

Noget i retning af:

SELECT t_url, t_info, t_value, COUNT(t_url) AS stk FROM tb_things GROUP BY t_url, t_info, t_value ORDER BY stk DESC, t_value DESC

Hvad skal jeg kalde den sidste? De andre hedder:
$ting[t-info]
$ting[t-value]

Hvad skal jeg skrive der hvor den skal vise billedet?

Alt hvad jeg har lavet indtil videre:



<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; border-width: 0\" bordercolor=\"#111111\" width=\"100%\" id=\"AutoNumber1\">
  <tr>
    <td width=\"25%\" style=\"border-style: none; border-width: medium\">&nbsp;</td>
    <td width=\"25%\" style=\"border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-top: medium none #111111; border-bottom-style: none; border-bottom-width: medium\">
    <b><font face=\"Verdana\" size=\"2\">Info:</font></b></td>
    <td width=\"25%\" style=\"border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-top: medium none #111111; border-bottom-style: none; border-bottom-width: medium\">
    <b><font face=\"Verdana\" size=\"2\">Værdi:</font></b></td>
    <td width=\"25%\" style=\"border-left-style: none; border-left-width: medium; border-right: medium none #111111; border-top: medium none #111111; border-bottom-style: none; border-bottom-width: medium\">
    <b><font face=\"Verdana\" size=\"2\">Antal der findes:</font></b></td>
  </tr>
<?
include("cont.php");

$tingliste=mysql_query("SELECT t_url, t_info, t_value, COUNT(t_url) AS stk FROM tb_things GROUP BY t_url, t_info, t_value ORDER BY stk DESC, t_value DESC") or die ("Databasen er lukket!");
while($ting=mysql_fetch_array($tingliste))
    {
    echo "  <tr>
    <td width=\"25%\" style=\"border-left: medium none #111111; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom: medium none #111111\">&nbsp;</td>
    <td width=\"25%\" style=\"border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom: medium none #111111\">$ting[t-info]</td>
    <td width=\"25%\" style=\"border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom: medium none #111111\">$ting[t-value]</td>
    <td width=\"25%\" style=\"border-style: none; border-width: medium\">&nbsp;</td>
  </tr>";
}
?>
</table>

Selvfølgelig -> <img src=gfx\things\$ting[t-url] border=0>

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting ']' in /web/www.skyskraber.dk/www/chatonline/tingliste.php on line 19


<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; border-width: 0\" bordercolor=\"#111111\" width=\"100%\" id=\"AutoNumber1\">
  <tr>
    <td width=\"25%\" style=\"border-style: none; border-width: medium\">&nbsp;</td>
    <td width=\"25%\" style=\"border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-top: medium none #111111; border-bottom-style: none; border-bottom-width: medium\">
    <b><font face=\"Verdana\" size=\"2\">Info:</font></b></td>
    <td width=\"25%\" style=\"border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-top: medium none #111111; border-bottom-style: none; border-bottom-width: medium\">
    <b><font face=\"Verdana\" size=\"2\">Værdi:</font></b></td>
    <td width=\"25%\" style=\"border-left-style: none; border-left-width: medium; border-right: medium none #111111; border-top: medium none #111111; border-bottom-style: none; border-bottom-width: medium\">
    <b><font face=\"Verdana\" size=\"2\">Antal der findes:</font></b></td>
  </tr>
<?
include("cont.php");

$tingliste=mysql_query("SELECT t_url, t_info, t_value, COUNT(t_url) AS stk FROM tb_things GROUP BY t_url, t_info, t_value ORDER BY stk DESC, t_value DESC") or die ("Databasen er lukket!");
while($ting=mysql_fetch_array($tingliste))
    {
    echo "  <tr>
    <td width=\"25%\" style=\"border-left: medium none #111111; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom: medium none #111111\"><img src=gfx\things\$ting[t-url] border=0></td>
    <td width=\"25%\" style=\"border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom: medium none #111111\">$ting[t-info]</td>
    <td width=\"25%\" style=\"border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom: medium none #111111\">$ting[t-value]</td>
    <td width=\"25%\" style=\"border-style: none; border-width: medium\">&nbsp;</td>
  </tr>";
}
?>
</table>

<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; border-width: 0\" bordercolor=\"#111111\" width=\"100%\" id=\"AutoNumber1\">
  <tr>
    <td width=\"25%\" style=\"border-style: none; border-width: medium\">&nbsp;</td>
    <td width=\"25%\" style=\"border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-top: medium none #111111; border-bottom-style: none; border-bottom-width: medium\">
    <b><font face=\"Verdana\" size=\"2\">Info:</font></b></td>
    <td width=\"25%\" style=\"border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-top: medium none #111111; border-bottom-style: none; border-bottom-width: medium\">
    <b><font face=\"Verdana\" size=\"2\">Værdi:</font></b></td>
    <td width=\"25%\" style=\"border-left-style: none; border-left-width: medium; border-right: medium none #111111; border-top: medium none #111111; border-bottom-style: none; border-bottom-width: medium\">
    <b><font face=\"Verdana\" size=\"2\">Antal der findes:</font></b></td>
  </tr>
<?
include("cont.php");

$tingliste=mysql_query("SELECT t_url, t_info, t_value, COUNT(t_url) AS stk FROM tb_things GROUP BY t_url, t_info, t_value ORDER BY stk DESC, t_value DESC") or die ("Databasen er lukket!");
while($ting=mysql_fetch_array($tingliste))
    {
    echo "  <tr>
    <td width=\"25%\" style=\"border-left: medium none #111111; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom: medium none #111111\"><img src=\"gfx\things\$ting[t_url]\" border=0></td>
    <td width=\"25%\" style=\"border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom: medium none #111111\">$ting[t_info]</td>
    <td width=\"25%\" style=\"border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom: medium none #111111\">$ting[t_value] points</td>
    <td width=\"25%\" style=\"border-style: none; border-width: medium\">$ting[stk]</td>
  </tr>";
}
?>
</table>

Så virker det undtagen billedet..

Så kører det sq :-)