function ListByParashah($parashah)
{
$parashah = str_replace("\\", "", $parashah);
$parashah = trim($parashah);
//
require 'mysql.php';
$result = mysql_query("SELECT filename, title, description, dir \n\t\t\t\t\t\t\tFROM descriptions \n\t\t\t\t\t\t\tWHERE parashah='" . mysql_real_escape_string($parashah) . "' \n\t\t\t\t\t\t\tORDER BY `dir` DESC, `filename` ASC");
mysql_close($con);
//store shiurim in array
$n = 0;
while ($row = mysql_fetch_array($result)) {
$shiurim['title'][$n] = $row['title'];
$shiurim['filename'][$n] = $row['filename'];
$shiurim['dir'][$n] = $row['dir'];
$shiurim['description'][$n] = $row['description'];
if (strcmp($shiurim['dir'][$n], 'mp3/') == 0) {
$shiurim['date'][$n] = '(2004 - 2007)';
} else {
if (strcmp($shiurim['dir'][$n], 'mp3/NC/') == 0) {
$shiurim['date'][$n] = '(2012)';
}
}
$n++;
}
//print out shiurim according to series
$currentSeries = $shiurim['dir'][0];
printHeadline('Classes for Parashas ' . $parashah . ' ' . $shiurim['date'][0]);
for ($i = 0; $i < sizeof($shiurim['dir']); $i++) {
if ($shiurim['dir'][$i] != $currentSeries) {
$currentSeries = $shiurim['dir'][$i];
printNewHeadline('Classes for Parashas ' . $parashah . ' ' . $shiurim['date'][$i]);
}
printShiur($shiurim['title'][$i], $shiurim['filename'][$i], $shiurim['description'][$i], $shiurim['dir'][$i]);
}
//echo '<br />';
}
if (strcmp($new_filename, $filename) != 0) {
if (!file_exists($new_path)) {
$sql = "UPDATE descriptions \n\t\tSET title='" . mysql_real_escape_string($title) . "',\n\t\tfilename='" . mysql_real_escape_string($new_filename) . "', \n\t\tdescription='" . mysql_real_escape_string($description) . "' \n\t\tWHERE filename='" . mysql_real_escape_string($filename) . "'";
mysql_query($sql, $con);
rename($old_path, $new_path);
//echo 'The title of '.$filename.' has been updated to: <b>'.$new_filename.'</b><br />';
printHeadline('Preview');
printShiur($title, $new_filename, $description, $dir);
printNewHeadline('Do Another Shiur');
} else {
echo 'Sorry the file ' . $new_filename . ' already exists. Please choose a different name.';
}
} else {
$sql = "UPDATE descriptions \n\tSET description='" . mysql_real_escape_string($description) . "' \n\tWHERE filename='" . mysql_real_escape_string($filename) . "'";
mysql_query($sql, $con);
printHeadline('Preview');
printShiur($title, $new_filename, $description, $dir);
printNewHeadline('Do Another Shiur');
}
?>
<form action="editdescription.php" method="post"
enctype="multipart/form-data">
<table>
<tr>
<td>Chumash/Series:</td>
<td><select name="chumash" id="chumash" onchange="getParashah()" >
<option value="Bereishit">Bereishit</option>
<option value="Shemot">Shemot</option>
<option value="Vayikra">Vayikra</option>
<option value="Bamidbar">Bamidbar</option>
<option value="Devarim">Devarim</option>