[needforhelp]

Hello,
I'm "generating" a form from the database,So the number of fields is always different.
Is there some way to submit such form?
Thanks in advance for any help!

[phpdoctor]

Do you have the code thats generates the form from the database?

[needforhelp]

Thanks for your response!
Here's the source code:

PHP Code:

<?php

if (!isset($_POST['btnsubmit'])) {
echo "
<form name='formmenu' method='post' action='navmenu.php'>
";
$count = 0; 
$query = 
mysql_query("SELECT * FROM navmnu ORDER BY position ASC") or die(mysql_error());
while ($row = mysql_fetch_object($query)) 
  { 
echo "
Link $count
Name <input type='text' name='field[]' value='$row->desc'
<input type='hidden' name='hfield[]' value='$row->desc'

<p>
URL <input type='text' name='field2[]' value='$row->link'
 <input type='hidden' name='hfield2[]' value='$row->link'

</p>
<hr>
";
    $count++;
  }
echo "<input type='submit' name='btnsubmit' value='submit!'>";

I've figured out how to insert,But now I'm attempting to figure out how to update the fields.
Here's a code to insert:

PHP Code:

foreach ($_POST['field'] as $field)
{
$value = htmlspecialchars($field);

mysql_query("INSERT INTO navmnu (name) VALUES ('" . $value . "')") or die();
} 

As you may see,I've added some hidden fields with the current values & attempted to do the update like that:

PHP Code:

    $value = htmlspecialchars($field);
    $value2 = htmlspecialchars($field2);
    mysql_query("UPDATE menu set name= VALUES ('" . $value . "') WHERE name= VALUES('" . $value2 ."')") or die(); 

But that doesn't seem to work.
Any help would be appreciated.
Thanks in advance!

[UnrealEd]

to update a database field, you have to use this query:

PHP Code:

mysql_query("UPDATE menu set name='" . $value . "' WHERE name= '" . $value2 ."'") or die(); 

UnrealEd

[needforhelp]

Thanks a lot for your reply!
I have the following code:

PHP Code:

foreach ($_POST['field'] as $field)



{

$value = htmlspecialchars($field);



}  

foreach ($_POST['hfield'] as $currentfield)



{

$currentvalue = htmlspecialchars($currentfield); 



mysql_query("UPDATE menu set name='" . $value . "' WHERE name= '" . $currentvalue ."'") or die();  

} 

it gives me the following error message:

Warning: Invalid argument supplied for foreach() in /public_html/admin/navmenu.php on line 101

I can't figure out what's wrong.

[UnrealEd]

that's because $_POST['hfield'] is not an array, but a string. and neither is $_POST['field']

you have to replace field2[] and hfield2[] with field[] and hfield[].
than it will work

UnrealEd

[needforhelp]

Thanks!
But now there's another problem:
It'll update all the rows to the value of the last field in the form.

[UnrealEd]

if i were you, i would just remove the hfield from your form, and just grab them on the form processing page.
then store the hfields in an array, where the keys matches the keys of the $_POST['field'] array. Then loop over the $_POST['field'] array and update the record in the database.

UnrealEd

[needforhelp]

Sorry for such a late response (I've made something else),But I can't seem to find a valid function for the updating part.
I've tried

PHP Code:

foreach ($_POST['field'] as $field) 

foreach ($_POST['hfield'] as $currentfield) 



$value123 = htmlspecialchars($field);

$currentvalue = htmlspecialchars($currentfield); 

mysql_query("UPDATE menu set name='" . $value123 . "' WHERE id= '" . $currentvalue ."'") or die();  

} 

But that didn't worked because it's adding the same value multiply times to all the rows.
So what's the correct PHP function to use?
Thanks in advance & sorry for so many troubles.

[UnrealEd]

try this:

PHP Code:

foreach($_POST['field'] as $k => $field){
  $value23 = htmlspecialchars($field);
  $currentvalue = htmlspecialchars($_POST['hfield'][$k]);
  mysql_query("UPDATE menu set name='" . $value123 . "' WHERE id= '" . $currentvalue ."'") or die(mysql_error());
} 

i'm not sure if it's gonna work though. just give it a try

UnrealEd