I need help
I am retrieving rows from MySQL table
now what I want is that as rows retrieved with each row and edit button will insert
but i don't know how to insert
here is my code
<?php
require('connect.php');
session_start();
$query="SELECT * FROM project WHERE projectstatus='Open'";
$result=mysql_query($query);
$num=mysql_numrows($result);
$i=0;$j=1;
while ($i < $num) {
$projectid=mysql_result($result,$i,"projectid");
$fkey=mysql_result($result,$i,"fkey");
$paying=mysql_result($result,$i,"paying");
$completionmonth=mysql_result($result,$i,"completionmonth");
$completiondate=mysql_result($result,$i,"completiondate");
$personspecify=mysql_result($result,$i,"personspecify");
$projecttitle=mysql_result($result,$i,"projecttitle");
$categories=mysql_result($result,$i,"categories");
$tools=mysql_result($result,$i,"tools");
$shortdescription=mysql_result($result,$i,"shortdescription");
$date=mysql_result($result,$i,"date");
$time=mysql_result($result,$i,"time");
$i++;
echo "<br>".$j."<br>";
echo "<br>".$projectid."<br>";
echo "<br>".$fkey."<br>";
echo "<br>".$paying."<br>";
echo "<br>".$completionmonth.' month '.$completiondate.' days '."<br>";
echo "<br>".$personspecify."<br>";
echo "<br>".$projecttitle."<br>";
echo "<br>".$categories."<br>";
echo "<br>".$tools."<br>";
echo "<br>".$shortdescription."<br>";
echo "<br>".$date."<br>";
echo "<br>".$time."<br>";
echo "<br>"."<br>"."<br>";
// I want to insert edit button here but dont know how
echo "------------------------------------------------------------------------"."<br>";
$j++;
}
?>
</body>
</html>