[php-list] Hi friends ! Need some help regarding php list update

[rohil]

Hello friends

I need some help regarding a site i am making. I need to finish it
really very urgently but seem to be stuck at this point.

The problem is that I am displaying all the rows of my table which
have the value of the field 'approval' as 0. Now, there are to be 2
buttons next to each row with names "Approve" and "Disapprove". If you
click on approve, then the value of 'approval' for that row becomes 1
and if you click on "Disapprove" , the value of 'approval' becomes -1.
How to accomplish it ? as the list being viewed will be changing very
often.

I used this for loop for displaying the list and the corresponding boxes~

db_connect();

$query="SELECT * from info where approval=0";
$process=mysql_query($query);
$num=mysql_num_rows($process);

for($i = 0; $i< $num; $i++)
       {
                $row = mysql_fetch_assoc($process);
                $title[$i]=$row['title'];
                $url4[$i]=$row['url'];
                $widget[$i]=$row['widget'];
                $box[$i]=$row['box'];
                $button[$i]=$row['button'];
                $id[$i]=$row['id'];
                }
echo "<table width=100% border='2' cellpadding='10' align='center'>";
echo "
    <th>title</th>
        <th>url</th>
        <th>widget</th>
        <th>box</th>
        <th>button</th>";

//displaying the list   
for($i = 0; $i< $num; $i++)
    {           
         echo "<tr>";
         
         echo "<td>".$title[$i]."</td>";
         echo "<td>".$url4[$i]."</td>";         
         echo "<td>".$widget[$i]."</td>";
         echo "<td>".$box[$i]."</td>";
         echo "<td>".$button[$i]."</td>";
        
        echo "<td>";

//creating two buttons - Approve and Disapprove

        echo "<form name='approve' method='post' action='pending.php'>\n";
        echo "<input  type= 'Submit' name= 'approve' value='approve' ";
        echo"</td>";            
        
        echo "<td>";
        echo "<form name='disapprove' method='post' action='pending.php'>\n";
        echo "<input  type= 'Submit' name= 'disapprove' value='Disapprove' ";
        echo"</td>";            

        echo "</tr>";


//Trying to perform the desired action but not working

        if(isset($_POST['approve']))
     {
           $sql = "UPDATE table info SET approval=1 WHERE url='".
$url[$i] ."' ";
           $result = mysql_query($sql);
     }
        
        if(isset($_POST['disapprove']))
     {
           $sql = "UPDATE table info SET approval=-1 WHERE url='".
$url[$i] ."' ";
           $result = mysql_query($sql);
     }
        
        
        }

-------------------------------------------------------------
There is the normal end coding after this. So, can anyone please
suggest a way for me to do this ? Its very very very urgent.

Thanks to you all,
Rohil