[us0r]

ok so I got this far but I'm not sure how I can update all rows of my query.

What I am trying to do is display customer names, product and price then have the option of putting in the USPS tracking number into a field I set up and click submit and update all records.

Here is what I got so far (and it works - just need to know how I can update all records):

<form method="POST" action="enterr.php">
<?php
mysql_connect("0.0.0.0", "orders", "programmingtalk", "orders")
or die("Could not connect: " . mysql_error());
mysql_select_db("orders");
$sql = ("SELECT first_name, last_name, product, cost FROM rkl_orders WHERE STATUS='1'");
$result = mysql_query($sql)
or die ("Could not do query: " . mysql_error());
while ($row = mysql_fetch_array ($result)) {
print("<tr><td>" . $row["first_name"] . " " . $row["last_name"] . "</td><td>RKL</td><td>" . $row["cost"] . "</td><td><input type=\"hidden\" name=\"name\" value=\"" . $row["first_name"] . " " . $row["last_name"] . "\"><input type=\"text\" name=\"track\" size=\"20\"></td></tr>");
}
mysql_close();
?>

I was going to use the hidden text box "name" and then update the "track" tabel in the DB where name = name.

I think I need to array this somehow any help would be greatly appreciated.

Thanks,
Ryan

[Marshall]

You could do something like

PHP Code:

UPDATE tablename SET track={$_POST['track']} WHERE first_name={$_POST['name']}; 

for the query to update the tables track id using the username.

[us0r]

nice!

I'll give it a try thanks!

[us0r]

it is only taking the last record.

any ideas?

[Marshall]

One recommendation though, assign userid #'s to people because if 2 people have the same first or last name it may get confused with which one it should choose, but if u have the people numbered u can refer to them by number and update it by number. Then you just have to associate that number with the login name and password so that when they login it can tell what their number is for table updating.


edit: If you need it to update multiple ones at the same time, you can do

PHP Code:

UPDATE tablename SET track={$_POST['track']}, name={$_POST['name'] WHERE first_name(or userid)={$_POST['name']} 

[us0r]

ok I think I got it but it will only update the last record in the select.

any ideas?

[blaw]

Hi there,

I think the problem is that you have the same field names across all the records (i.e. "name" and "track" for each record's "name" and "track").

Try using arrays (i.e. "track[]" and "name[]") as field names if you have more than one pair, then loop through the POST vars to UPDATE each record.

My 2 cents.