here is my code.i have checkboxes beside the data from MySql table. once i select some options in check box respective data should be sent to the datatable.pls help me out.
i'm not able to insert data into the table (resumes)
<?php
$sql=mysql_connect("localhost","root");
if($sql)
echo "";
else
echo"not connected";
mysql_select_db("adps",$sql);
$select3="select * from jobs" ;
$query3=mysql_query($select3,$sql);
{ // see if any rows were returned
if (mysql_num_rows($query3) > 0) {
echo "<table border=2>
<tr><th>Job Id</th><th>Job Title</th><th>Job Description</th><th>Post Start Date</th><th>Post End Date</th</tr>";
while($row=mysql_fetch_array($query3))
{
echo "<tr><td>".$row["jobid"]."</td>";
echo "<td>".$row["jobtitle"]."</td>";
echo "<td>".$row["jobdesc"]."</td>";
echo "<td>".$row["poststartdate"]."</td>";
echo "<td>".$row["postenddate"]."</td>";
print "<TD ALIGN=CENTER ><input type=checkbox name=Apply[] value=Apply></TD>\n";
echo "</TR>";
}
mysql_free_result($query3);
}
}
print ("</TABLE>\n");
echo "<input type=submit value=Apply>";
?>
<?phpif(isset(Apply)){
for($i=0;$i<count(Apply);$i++)
mysql_select_db("adps",$sql);
$insert=insert into resumes(jobid) values($jobid);
$query=mysql_query($insert,$sql);
if($query)
echo "inser😕ed resumes";
else
echo "not resumes";
require("3.html");
?>
