Code weird

passagewds

I can't figure out why the information from the database is not displaying on the screen, the database is in ok, because it can get all the distinct types and can display each of them seperately, just won't display the information from each link.

www.ipa-region14.ca/canada/accomodations.php

$disply= "SELECT DISTINCT Type FROM $dbtable";
$qry = mysql_query("$disply") or die ('I cannot run select because: ' . mysql_error());
while ($row = mysql_fetch_assoc($qry))
{
extract($row);
$link = str_replace(' ', '_', $Description);
echo "<h2>$Type</h2>\n";
echo "<table width='100%' border='1'>";
$snd_disply = "SELECT * FROM $dbtable WHERE Type='$Type' ORDER BY City DESC";
$category=$Type;
echo "$category";
$snd_qry = mysql_query("$disply") or die ('I cannot run select because: ' . mysql_error());
while ($snd_row = mysql_fetch_assoc($snd_qry)) {
extract($snd_row);
// Display data
echo "$Name<tr><td>";
echo "<a href='$URL'>$Name</a>";
echo "</td><td><div align='right'>$City</div></td>
<td></td>
</tr>\n
<tr>
<td colspan='3'>$Description</td>
</tr></table>\n
";
}
echo "$Name";
echo "$snd_row aaaa $Description";
}

xblue

hi, first of all: pleae use the [php] [/php] tags when posting code, it makes it easier to read.

then I'd clean it up a little even before starting to debug: you only need one query instead of that nested while loops I think.

the query should be something like

SELECT * FROM $dbtable WHERE ORDER BY Type, City DESC

then you only need to keep track of the previous type, and display it only when it changes. simplified example:

$prev_type = '';
while ($row = mysql_fetch_assoc($qry)) {
    extract($row); 
    if ($Type != $prev_type) {
        echo "<h2>$Type</h2>\n"; 
        $prev_type = $Type;
    }
    // echo rest of data
}
unset($prev_type);