The following code successfully displays summary's from the DB.
How would I go about editting or deleting the summaryId?
It doens't appear to be passed with either the link or button i've created.
Any tips?
tia, will
Code: Select all
while($query_data = mysql_fetch_array($result)) {
$summaryId = $query_data["summaryId"];
$paperCategory = $query_data["paperCategory"];
$colloPaperName = $query_data["colloPaperName"];
$stockId = $query_data["stockId"];
$stockDescription = $query_data["stockDescription"];
$adhesiveDescription = $query_data["adhesiveDescription"];
$linerDescription = $query_data["linerDescription"];
$supplier = $query_data["supplier"];
echo "<tr class=row1>\n";
echo "<td width=\"150px\">$summaryId</TD>\n";
echo "<td width=\"115px\">$paperCategory</TD>\n";
echo "<td width=\"150px\">$colloPaperName</TD>\n";
echo "<td width=\"150px\">$stockDescription</TD>\n";
echo "<td width=\"150px\">$adhesiveDescription</TD>\n";
echo "<td width=\"150px\">$linerDescription</TD>\n";
echo "<td width=\"100px\">$supplier</td>\n";
echo "<td>
<input class=\"btnSmall\" type=\"submit\" value=\"Edit\" name=\"editSASummary\"\">
<a href = search.php?action=editSASummary&summaryId=".$summaryId.">Edit</a></td>\n";
echo "<td>
<input class=\"btnDelete\" type=\"submit\" value=\"Delete\" name=\"delete\" onClick=\" return confirm('Are you sure you want to delete this record?')\"></td>\n";
echo "</tr>\n";
}
echo "</form></table>";
}