first of all, thanks alot for ur responses...
this is
searchjob.php
---------------------------------------------------------------
<? ob_start(); ?>
<html>
<form method="POST" action="search.php">
<body bgproperties="fixed" background="c4.bmp">
<?php
$user=$_POST[user];
$conn=mysql_connect("localhost","username","passwo rd");
mysql_select_db("database",$conn);
$result = mysql_query("SELECT * FROM posting where job_keywords='$keyword'", $conn) or die("error querying database");
\\posting is the table where the list of jobs are stored.
?>
<table border="2" cellspacing="1" width="100%">
<tr>
<th>Position</th>
<th>Job Responsibility</th>
<th>Job Level</th>
<th>Job location</th>
<th>Functional area</th>
<th>Salary</th>
<th>Apply</th>
<th>Review</th>
<th>Not Interested</th>
</tr>
<?
$i = 0;
while($result_ar = mysql_fetch_assoc($result)){
?>
<input="text" name="post_id[<? echo $i?>]" value="<?php echo $result_ar['post_id'];?>">
<tr>
<td><?php echo $result_ar['position']; ?></td> \\columns of table 'posting'
<td><?php echo $result_ar['job_responsibility'];?></td>
<td><?php echo $result_ar['job_level'];?></td>
<td><?php echo $result_ar['location_of_job'];?></td>
<td><?php echo $result_ar['job_functional_area'];?></td>
<td><?php echo $result_ar['job_salary'];?><br></td>
<td><input type="radio" value="apply" name="choice[<?echo $i?>]"></td>
<td><input type="radio" value="review" name="choice[<?echo $i?>]"></td>
<td><input type="radio" value="not_interested" name="choice[<?echo $i?>]"></td>
</tr>
<?php
$i+=1;
}
?>
</table>
</br></br>
&n bsp;
&n bsp;
&n bsp;
&n bsp;
&n bsp;
&n bsp;
<input type="hidden" value="<?echo $user?>" name="user">
<input type="hidden" value="<?echo $i?>" name="i">
<input type="Submit" value="Submit" name="Submit">
</form>
</html>
</body>
<? ob_end_flush(); ?>
--------------------------------------------------------------------
The reason i m using radiobuttons instead of checkboxes is, i dont want the user to select both 'not interested' checkbox and 'apply' checkbox. i have not written the 'search.php' script yet. because i m not sure how to insert the values to the table. table structure is as follows:
table name:
search
username,post_id,choice,data_applied.
i want to insert only those records whose values is 'apply' . i m confused. how do i know if the button which is selected is 'apply'(either radio/checkbox). if the searchjob.php return list of 100 jobs and user "apply" for 80 jobs and click on submit, i want to insert those 80 jobs where the user has selected 'apply'. i m so **** confused with this.
