I have created a select that then lists the results in a while loop and posts them to the result page.
What I want to then do is click (href) on one of the listed rows and insert a new row with some of the properties of the record clicked on.
In other words, rather than going to a form, inputting values, then inserting those values into a new row, I want to create a new row by automatically carrying over some/all of the values that are in the previous row.
Below works if I start with a form page and input the values for value1, value2, and value3:
$sql = "INSERT INTO $table_name
(value1,value2,value3)
VALUES
(\"$value1\",\"$value2\",\"$value3\")";
$result = @($sql, $connection) or die("Error #". mysql_errno() . ": " . mysql_error());
...but what I want to do is set the \"$value1\" etc. rows to the value from the row of the href'd row.
Is there a way to do this?
