Show text instead of row data - PHP /MYSQL

Show text instead of row data - PHP /MYSQL

I have a search engine connected to a database that gives the results in a
table.
Here is how table looks like:
The column, organizer_id contains a number used as reference. Instead
should be the organizer name.
Ex:
1280132044 should be Corporate Inc
Can you give me a hand how to make this? I'm new in PHP/MYSQL


Here is the code to print the results:
while ($row = mysql_fetch_assoc ($result)) {
echo "<tr>\n";
printf("<td><a href='http://embs-group.com/%s,%s'>%s</a></td>",
$row['id'], str_replace(" ", "_", $row['name']), $row['name']);
printf("<td>%s</td>", $row['organizer_id']);
printf("<td>%s</td>", $row['no_pages']);
printf("<td>%s</td>", $row['publication_date']);
printf("<td>%s</td>", $row['price']);
printf("<td>%s</td>", $row['currency']);
echo "</tr>\n";
}
echo "</TABLE>\n";
}