Re: Showing recordsets from tables with one (main table) to many (secondary table) relationship

[Kostas Telias]

Thank you Rick.

Finally, the question for which i started this 'large' thread (it appears in the thread topic): in a specific moment in the application, i need to show, for each specie (main table: tbltaxonomia), its vernacular names (secondary table: tblnombresvernaculos). Is there a better way of doing than this:

$resultVernaculaNames=$conn->query("SELECT * FROM tblnombresvernaculos WHERE Id=$rowspecie[0] ORDER BY order");
while ($rowVernacularNames=$resultVernaculaNames->fetch_row()){
printf(
"<span class='verncaularname'>%s %s %s</span><br>",
$rowVernacularNames[1],$rowVernacularNames[2],$rowVernacularNames[3]
);
}

The table tblnombresvernaculos, like it can be understood, has four fields, the first of them is Id, the foreign key with the table tbltaxonomia.