rukshilag 0 Junior Poster

Hi,
well what i need to do is, through a certain interface there are assignment upload calls given by the admin, this is that interface

<html>
<head>
<script type="text/javascript">

function remlink(num){
var rownum=num;
var rowid = "subname_"+rownum;
var sn=document.getElementById(rowid).innerHTML;

var cnfrm = confirm ("Are you sure you want to remove this link?");

if(cnfrm){
var querystring="?sn=" + sn;
window.location = "http://localhost/drupal/node/27"+querystring;
}

}

</script>
</head>


<b>NEW SUBMISSION LINK</b>
<form action="http://localhost/drupal/node/27" method="POST">
<table>
<tr><td>Submission Name</td><td><input type="text" name="sub_name"/></td></tr>
<tr><td>Maximum file size</td><td><input type="text" name="max_mb" size="1" value="2" maxlength="3"/>MB</td></tr>
<tr><td>Support File</td><td><input type="file" name="sup_file" size="30"/></td></tr>
<tr><td></td><td><input type="submit" name="sub_sub" value="OK"/></td></tr>
</table>
</form><br><br>

<?php

$sub_name=$_POST['sub_name'];
$max_mb=$_POST['max_mb'];
$sup_file=$_POST['sup_file'];

mysql_connect("localhost", "root", "");

mysql_select_db('sdc_assign');

$insertq="INSERT INTO due_subs (sub_name, max_mb, sup_file) VALUES ('$sub_name', '$max_mb' , '$sup_file')";

if(!$sub_name==""){
$res=mysql_query($insertq);
if($res){ echo "Link Created for: " . $sub_name . "<br/>"; }
else{ echo "COULD NOT CREATE LINK. LINK MAY ALREADY EXIST"; }
}

?>

<?php

$subnameid=$_GET['sn'];
if(!$subnameid==""){
$deleteq="DELETE FROM due_subs WHERE sub_name='$subnameid'";
mysql_query($deleteq);
}
?>

<br>
<b>REMOVE SUBMISSION LINK</b>
<br/><br/>
<form>
<table>

<?php
$selectq="SELECT * FROM due_subs";
$result=mysql_query($selectq);

$i=0;
while($row=mysql_fetch_array($result)){
echo "<tr><td>";
echo "<div id='subname_$i'><a href='http://localhost/drupal/node/29'>";
echo $row['sub_name'];
echo "</div>";
echo "</td><td>";
echo "<input type='button' value='REMOVE' onclick='remlink($i)'/>";
//echo "<form action='http://localhost/drupal/node/29/' method='post'><input type='button' value='CHECK' onclick=''/></form>";
echo "</td></tr>";
$i++;
}
?>


</table>
</form>

</html>

when the admin uploads a link for students to upload their assignments, students will be abel to upload.
now what i need to do is, thru that interface i have shown u, to have a link per assignment link which i can check all uploaded assignments.

how can this be done?