I'm trying to display data from an external database inside a WordPress page.
So far so good with Woody Snpippets that works quite fine. I can display Firstname, Lastname and Year of birth from our sport club swimm team members.
Additional I would like to display a picture of each member, which doesn't com from the database. it could be loaded from filesystem or an URL (based on the used Nextgen Gallery plugin). The picture can be identified by teh name schema whatever/path/firstname.lastname.png.
Any idea how to realize that?
This is the code which displays the data:
So far so good with Woody Snpippets that works quite fine. I can display Firstname, Lastname and Year of birth from our sport club swimm team members.
Additional I would like to display a picture of each member, which doesn't com from the database. it could be loaded from filesystem or an URL (based on the used Nextgen Gallery plugin). The picture can be identified by teh name schema whatever/path/firstname.lastname.png.
Any idea how to realize that?
This is the code which displays the data:
PHP:
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo $row["Vorname"]." ". $row["Nachname"]. "<br>";
echo "Jahrgang ". $row["Jahrgang"]. "<br /><br />";
}
} else {
echo "0 results";
}