SELECT multiple records and append.

fotofx

I have a very simple table called replist with 3 fields, (Lname, Fname, Notes).

I want to list these records with a checkbox next to them. I then want to be able to check off some/all of these boxes and enter comments in a text box. Once the save button is pressed I want the entered text to be appended to the existing data in each Notes field and maybe display the number of rows affected.

Any help will be appreciated..

dagon

and what code do you have so far?

fotofx

Really nothing much, I obviously can do the SELECT and populate the query but this is going to be a bit wierd because I will need rows of form? I am guessing to have the checkboxes available? I figure I will need a SELECT * to get all the rows then spit them out one at a time with a checkbox. I then need to figure how to only append to the selected rows...

Thanks
Steve

Kudose

Please post the code you have done and we will help you solve the problems you have questions for. 🙂

fotofx

Here is the basic code.

<?php
require("database.php");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table align="center">
<td align="center" valign="top">
<?php
$qry = "";
		$qry =  "select * from replist order by replist Lname";
$query = mysql_query;
print("<table class=Table>");
print("<tr class=Header>");
while ($line = mysql_fetch_array($query)) {
 	echo "<tr><td><small>" . $line['Lname'] . ',' . $line['Fname'] . "</small></td></tr>";}}
		}
?>
</table>
</body>
</html>

fotofx

Anybody?

Thanks
Steve