Update and remove with radio check
I got a table I'm using one one item as featured which value = 1 
rest of them value = 0

This is the list

        <table cellspacing="0" cellpadding="0">
    <form action="" method="POST">
    
    <tr>
        <th width="6%" >Featured</th>
        <th width="35%">Job Title</th>
        <th width="24%">Category</th>
        <th width="15%">Location</th>
        <th width="10%">Status</th>
        <th width="10%">Action</th>
    </tr>
    <?php	
    while($row = mysql_fetch_array($result))
    {
    ?>
    <tr>
    	<td width="6%" align="center">
    		<input type="radio" name="featured" value="<?php echo $row['job_id']; ?>" 
    	    <?php echo ($row['featured'] == 1?'checked':'')?>/>
    	</td>
    	<td width="35%"><?php echo $row['job_title']; ?></td>
    	<td width="24%"><?php echo $row['category_name'] ?></td>
        <td width="15%"><?php echo $row['job_location']; ?></td>
    	<td width="10%"><?php echo $row['status'] ?></td>
    	<td width="10%"><a href="job_edit.php?id=<?php echo $row['job_id']; ?>">Edit</a></td>
    </tr>
    <?php
    }
    ?>
    </tr>
    <tr class="box_foot">
    
    	<td colspan='6'><div class="save_b"><input type="submit" class="button_save buttons" name="submit" value="Continue"></div></td>
    </form>
    </table>
    </div>

When I choose a value that needs to be featured=1 
rest of them must be featured=0 in the table 
Update and remove with radio check
===

I got a table I'm using one one item as featured which value = 1 
rest of them value = 0

This is the list

        <table cellspacing="0" cellpadding="0">
    <form action="" method="POST">
    
    <tr>
        <th width="6%" >Featured</th>
        <th width="35%">Job Title</th>
        <th width="24%">Category</th>
        <th width="15%">Location</th>
        <th width="10%">Status</th>
        <th width="10%">Action</th>
    </tr>
    <?php	
    while($row = mysql_fetch_array($result))
    {
    ?>
    <tr>
    	<td width="6%" align="center">
    		<input type="radio" name="featured" value="<?php echo $row['job_id']; ?>" 
    	    <?php echo ($row['featured'] == 1?'checked':'')?>/>
    	</td>
    	<td width="35%"><?php echo $row['job_title']; ?></td>
    	<td width="24%"><?php echo $row['category_name'] ?></td>
        <td width="15%"><?php echo $row['job_location']; ?></td>
    	<td width="10%"><?php echo $row['status'] ?></td>
    	<td width="10%"><a href="job_edit.php?id=<?php echo $row['job_id']; ?>">Edit</a></td>
    </tr>
    <?php
    }
    ?>
    </tr>
    <tr class="box_foot">
    
    	<td colspan='6'><div class="save_b"><input type="submit" class="button_save buttons" name="submit" value="Continue"></div></td>
    </form>
    </table>
    </div>

When I choose a value that needs to be featured=1 
rest of them must be featured=0 in the table 