Dynamic Forms - create and update table

Anon

I create a form using this code:

while ($row = mysql_fetch_array($query))
{
$a= $row['a'];
$b= $row['b'];
$display_block .=
"<tr>
<td><input type=text name='a[]' value='$a ></td>
<td><input type=text name='b[]' value='$b ></td>
";
}

I display the form. Then input new data into the form and submit. The question is how do I update the table on the new page?

$sql = "UPDATE $table_name SET
b = \"$b\"
WHERE a = \"$a\"
";
$result = mysql_query($sql,$connection)
or die("Couldn't execute query.");

$a is not changed in the table. It is an ID number. $b is changed.

I am either missing something simple, or this is really complicated and I don't have a clue.

hessian

Ok two thoughts, first on your input value= you only have one ' with out close this may cause problems...

Second, I dont know if this is a problem or not, but you are not really assigning a result when you are doing an update the function is returning true or false.

It may not be, but I have never tried to assign a result when it was an update or insert.
if(!mysql_query($sql, $connection))
{
echo "Query Failed";
}

Not sure if either of those help, but hey i tried.

If this doesn't help.... Maybe tell us what errors you are getting.

ruppelm

Hi!

If $a is not going to be changed I would not put an input-field in the form.

I would do something like that:

Create Form:

<?php

$i = 0;
while ($row = mysql_fetch_array($query))
{
$a= $row['a'];
$b= $row['b'];
$display_block .= "<tr>
<td> $a <input type=\"hidden\" name=\"a[$i]\" value=\"$a\"></td>
<td><input type=\"text\" name=\"b[$i]\" value=\"$b\"></td>
</tr>";

$i++;
}

Update database:

<?php

for ($i=0; $i<sizeof($a); $i++)
{
$sql = "UPDATE $table_name SET
b=\"". $b[$i] ."\"
WHERE a=\"". $a[$i] ."\"
";
$result = mysql_query($sql,$connection)
or die("Couldn't execute query.");

}

I could not test the code, so sorry for possible typos.

Cheers, Markus

Anon

I worked on it for several hours after I posted this message, and I came up with similar code for the UPDATE page.

It just seems wrong 🙂
But it works! 😃

Thanks!!