[Bonzo]

I have an idea what I am supposed to do but cant think about how !

I am reading the rows from the database; editing if reqiured, changing "N" to "Y" and updating database.

If approve set to "N" ( default form submision form ) it will not be displayed and if set to "Y" it will be - on another page.

PHP Code:

<?php



$query = "SELECT name, text, approve FROM data WHERE approve ='N'";

$result = mysql_query($query);

$num_results = mysql_num_rows($result);



echo '<form method="POST" action="',$PHP_SELF,'">';



for ($i=0; $i <$num_results; $i++)

  {

    $row = mysql_fetch_array($result);



echo "<br>Text :<input type='text' name='text",$row[$i],"' size='30' maxlength='255' value ='",$row['text'],"'";

echo "<br>Approve :<input type='text' name='approve",$row[$i],"' size='3' maxlength='1' value ='",$row['approve'],"'<br>";

echo "<br><input type='hidden' name='name'",$row[$i],";



$update = "UPDATE data SET text = $row['text'], approve = $row['approve'] WHERE name = $row[$i]['name']";

$change = mysql_query($update);



}

?>

<br><input type="submit" name="submit" value="submit">

</form>

What I think should happen is when the data is altered and submit is pressed the data should go into an array and then I need another loop to update the database ?

Can someone point me in the right direction please?

Anthony

[Bonzo]

Loads of typing mistakes in the code !!

Getting closer now; just this error :You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '[0], approve = approve[0] WHERE name = 'name[0]'' at line

I am now posting to another page to update db.

PHP Code:

<?php

        $query = "SELECT name, text, approve FROM data WHERE approve ='N'";

        $result = mysql_query($query);

        $num_results = mysql_num_rows($result);



echo '<form method="POST" action="confirm.php">';



for ($i=0; $i <$num_results; $i++)

    {

    $row = mysql_fetch_array($result);



    echo "<br>Text : <textarea name='text[]'>",$row['text'],"</textarea>";

    echo "<br>Approve :<input type='text' name='approve[]' size='3' maxlength='1' value ='",$row['approve'],"'><br>";

    echo "<br><input type='hidden' name='name[]'>";

     }



     echo '<br><input type="submit" name="delete" value="submit"></form>';



     $delete = array();

     $delete = $_POST['delete'];

?>



<?php

 session_start();



   $count = count($_POST['delete']);

   

   echo "count = ",$count;



   for ($i=0; $i<$count; $i++)

  {

                  echo "<br>",$text[$i]; echo "<br>",$approve[$i]; echo "<br>",$name[$i];



       $done = mysql_query("UPDATE data SET text = text[$i], approve = approve[$i] WHERE name = name[$i]")or die(mysql_error());

     }

?>