function showAllTranscriptions()
{
$query = "select * from recordings where transcribed is null";
$result = mysql_query($query) or die(mysql_error());
if (mysql_num_rows($result) == 0) {
echo "<div class='transcription_block'>There are no calls to transcribe right now</div>";
}
for ($index = 0; $index < mysql_num_rows($result); $index++) {
$row = mysql_fetch_array($result);
showTranscription($row);
}
}
<?php
require_once "connect.php";
require_once "pages.php";
$query = "select * from recordings where transcribed!='1'";
$result = mysql_query($query) or die(mysql_error());
printHeader();
for ($index = 0; $index < mysql_num_rows($result); $index++) {
$row = mysql_fetch_array($result);
showTranscription($row);
}
printFooter();
function showTranscription($row)
{
$url = $row['url'];
$id = $row['recording_id'];
$transcriptionName = "transcription" . $id;
echo "<div class='transcription_block'>\n<div class='recording'>\n<EMBED height='50' SRC='{$url}' VOLUME='50' loop='false' controls='console' AUTOSTART='FALSE' width='90%'>\n</div>\n<div class='transcription'>\n<textarea id='{$transcriptionName}' cols='80' rows='5'>Enter your transcription here</textarea>\n</div>\n<div class='button'>\n<button name='transcribe'>Save Transcription</button>\n</div>\n</div>\n\n";
}