Is this possible

[kiwis]

To retrive all my records from a database and then edit them in a text box and click save to update them all???

[Chroder]

Of course

[kiwis]

how does the query look?

if (! mysql_query ("UPDATE DB_Stats Values ('','$name','$team','$tries','$goals','$fgoals','$total')")) 
  die ('Query Failed: ' . mysql_error()); 

Does it work out itself which record is getting updated itself?

[Chroder]

No, you have to tell it which query you're updating or else it'll update the entire table with the same info You should have a unique primary key, use that in thr query.

mysql_query("UPDATE DB_Stats VALUES ('','$name','$team','$tries','$goals','$fgoals','$total') WHERE my_unique_key=$thiskey") or die('Query Failed: ' . mysql_error()); 

[kiwis]

Originally posted by Chroder
No, you have to tell it which query you're updating or else it'll update the entire table with the same info You should have a unique primary key, use that in thr query.

mysql_query("UPDATE DB_Stats VALUES ('','$name','$team','$tries','$goals','$fgoals','$total') WHERE my_unique_key=$thiskey") or die('Query Failed: ' . mysql_error()); 

How do I set there when I have all records showing!!

WHERE my_unique_key=$thiskey")

[Chroder]

I think the easiest way would be to use each form element as an array, with the key being the ID. Let's pretend you have "id", "username" where "id" is the unique ID. You'd print your forms like:

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

while($row = mysql_fetch_array($result))
{
    // Makes (for example) an input element "username[1]", where 1 would be your primary key.
    echo '<input type="text" name="username[' . $row['id'] . ']" value="' . $row['username'] . '" />';
}

echo '<input type="submit" /></form>'; 

Then you can loop through the username array, adding to SQL to execute:

foreach($_POST['username'] as $k => $v)
{
    mysql_query("UPDATE DB_Stats VALUES('', $v) WHERE id=$k") or die('Error');
} 

Not sure how easy that was to understand

Basically,
1. Use arrays for your forms and identify the key as your table's primary key
2. Loop through the arrays you made for your form, and use the key as your WHERE clause.

[kiwis]

<?php

mysql_connect (localhost, user, pass);
mysql_select_db (nz);

if ("UPDATE DB_Stats VALUES ('','$name','$team','$tries','$goals','$fgoals','$total' WHERE id= $id") or die('Query Failed: ' . mysql_error);


?>

Parse error: parse error in /home/httpd/vhosts/httpdocs/savestatedit.php on line 17

help

[kiwis]

Originally posted by Chroder
I think the easiest way would be to use each form element as an array, with the key being the ID. Let's pretend you have "id", "username" where "id" is the unique ID. You'd print your forms like:

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

while($row = mysql_fetch_array($result))
{
    // Makes (for example) an input element "username[1]", where 1 would be your primary key.
    echo '<input type="text" name="username[' . $row['id'] . ']" value="' . $row['username'] . '" />';
}

echo '<input type="submit" /></form>'; 

Then you can loop through the username array, adding to SQL to execute:

foreach($_POST['username'] as $k => $v)
{
    mysql_query("UPDATE DB_Stats VALUES('', $v) WHERE id=$k") or die('Error');
} 

Not sure how easy that was to understand

Basically,
1. Use arrays for your forms and identify the key as your table's primary key
2. Loop through the arrays you made for your form, and use the key as your WHERE clause.

Cool got it all in my code!! I get "error" hmmm i have id and just name as two fields

what could be wrong??