MySQL Question

[Anon]

Hey,

I have a table with 5 columns; id, name, email, code, and ip. id is set to auto_increment. Now, I have one form that adds rows with just the code column filled and the other columns left blank. I want the second form to update the rows by adding the rest of the fields one by one, but I don't know how to do this. I know how to use UPDATE, but I don't know how to make it so it doesn't keep updating the same field, but rather it does one row at a time, each time someone submits the form.

Any ideas?

Thanks.

[jc94062]

So you just want to go through every row in the table updateing each one at a time?

There are several ways of doing this, and this may not be the best way, but its the way that looks the clearest and it will work. (I'm paranoid with a bug with fetch_array atm 😃)

$query = mysql_query("select * from table_name");
while ($rows = mysql_fetch_array($query))
{
$id[] = $rows[id];
$name[] = $rows[name];
$email[] = $rows[email];
$code[] = $rows

;
    $ip[] = $rows[ip];
}

for ($i=0;$i<count($id);$i++)
{
    $query = "update table_name set name='$name[$i]', email='$email[$i]', code='$code[$i]', ip='$ip[$i]' where id='$id[$i]";
    $result = mysql_query($query);
}

That should work.

[Anon]

I got this error:

Fatal error: [] operator not supported for strings in /usr/local/apache/htdocs/register/signup.php

I'm not sure if this is what I was looking for. I wanted it to update a unique row each time the form is submited, so it updates a new row each time you run the code.

Thanks for the help