Submitting multiple records

raouleduke

I am trying to submit multiple records to the database and, submit is not working, I want to be able to either submit one at
a time or all at once. Please help!

 <?php 
	mysql_connect(""); 
	mysql_select_db(""); 
	$query = "SELECT * FROM KEYCAD WHERE Hold LIKE 'Y' AND Active LIKE 'N'  ORDER BY CUSTNO AND ContactDate DESC";
	$result = mysql_query($query);
	echo "<form method='post' action='submit.php?action=change'>"; 
	while ($row = mysql_fetch_array($result)) {
	echo "<table border=2 bordercolor=#5E3964>\n";
	echo "	<tr>
			<td><font color=#FF0000>Set Active</font></td>
			<td><font color=#FF0000>Name</font></td>
			<td><font color=#FF0000>Home #</font></td>
			<td><font color=#FF0000>Bus #</font></td>
		 	<td><font color=#FF0000>Fixed Correctly?</font></td>
			<td><font color=#FF0000>Treatment?</font></td>
			<td><font color=#FF0000>Clear Explanation?</font></td>
			<td><font color=#FF0000>Overall Service?</font></td>
			<td><font color=#FF0000>Why Not Fixed?</font></td>
			<td><font color=#FF0000>Comments</font></td>
			</tr>\n";
	printf("
	<tr>
	<input type='hidden' name=RO value='%s'>
	<td><input type=checkbox name=Active value='Y'></td>
	<td>%s</td>
	<td>%s</td>
	<td>%s</td>
	<td><input type=text name=Q1 value='%s'></td>
	<td><input type=text name=Q2 value='%s'></td>
	<td><input type=text name=Q3 value='%s'></td>
	<td><input type=text name=Q4 value='%s'></td>
	<td><input type=text name=Q5 value='%s'></td>
	<td><input type=text name=Comments value='%s'></td>
	</form>
	</tr>
	</table>\n",

$row["RO"], 
$row["CUSTOMERNAME"], 
$row["HOMEPHONE"],
$row["BUSPHONE"], 
$row["Q1"],
$row["Q2"],
$row["Q3"],
$row["Q4"],
$row["Q5"],
$row["Comments"]
);
}
echo "<input type=Submit name=submit value=Submit>\n"; 
?>

Here is the submission page:

$RO = $_POST['RO'];
$Active = $_POST['Active'];
$CUSTOMERNAME = $_POST['CUSTOMERNAME'];
$HOMEPHONE = $_POST['HOMEPHONE'];
$BUSPHONE = $_POST['BUSPHONE'];
$Q1 = $_POST['Q1'];
$Q2 = $_POST['Q2'];
$Q3 = $_POST['Q3'];
$Q4 = $_POST['Q4'];
$Q5 = $_POST['Q5'];
$Comments = $_POST['Comments'];


mysql_connect(""); 
mysql_select_db(""); 
if($Active=='Y'){
$query = "UPDATE KEYCAD SET Active='Y', Q1='$Q1', Q2='$Q2', Q3='$Q3', Q4='$Q4', Q5='$Q5', Comments='$Comments'  WHERE RO=$RO";
}else{
$query = "UPDATE KEYCAD SET Active='N', Q1='$Q1', Q2='$Q2', Q3='$Q3', Q4='$Q4', Q5='$Q5', Comments='$Comments'  WHERE RO=$RO";
}

$result = mysql_query($query) or die(mysql_error());

?>

chads2k2

Show us how your inserting them into the database. .. also look at your name properties.

notice the ' ' in the name= part? Put those in and see if that helps... if not then just put up your code. Lata!

raouleduke

I edited my original field.

ahundiak

As a start, you need to make your data fields arrays i.e. use name=RO[] instead of name=RO. Right now, each row of data is overwriting the previous row because all the field names are the same.

With this change, $RO = $_POST['RO'] gives you an array of values.

Second problem will be your checkbox.

$Active = $_POST['Active'] will yield an array for those rows actually checked. Unlike $RO, $Active will not be a complete array. What you need to do is to store the $RO (or some other index) into the value of your check box.

Then, as you cycle through your update statement, search $Active to determine if active should be Y or N.

chads2k2

Yeah I agree with the other person who wrote in.

raouleduke

When I do that all I get in the update statement is the word array where the value should be. Also I put an echo"</form>"; statement after the print and it allows me to use each button. but does not submit the correct values just does the last one.
Thanks in advance

ahundiak

Can you post the generated html code with a couple of records in it?

raouleduke

For the first page or for the submit page. I think you mean the submit page, so here goes.
UPDATE KEYCAD SET Active='Y', Q1='Array', Q2='Array', Q3='Array', Q4='Array', Q5='Array', Comments='Array' WHERE RO=Array
Unknown column 'Array' in 'where clause'

ahundiak

I meant the actual generated html (what you see with a View Source command).

But I suspect that you are not treating your inputs as arrays.

You need something like

for($i = 0; $i < count($RO); $i++)
{
/ Build your sql statement /
$sql = "UPDATE keycad SET Q1='$Q1[$i]' ...
}

raouleduke

That works but works just like it did before, I am not having a problem updating records just when I print out the different records into one form it is only the first form that works, not the second one, third and so on. I want to be able to submit any record or all records at once.
thanks in advance.

ahundiak

Which leads us back to my original request that you post the generated html. I'm sure you have some syntax problems in it that would be easy to spot.

raouleduke

I did that, thanks, figured it out right away, sometimes you get so into something that you miss the obvious. I just moved the top Form statement inside the while statement. Just have a few more questions, I want to be able to also submit all the records at once any ideas. And on my submit page, I need to specify what do to by what CustomerNotReached=='1', you can see it in the code, but it is not working it is always setting the hold to Y.
Thanks again for all your help!

<?php

$RO = $_POST['RO']; 
$FollowUpContact = $_POST['FollowUpContact']; 
$CustomerNotReached = $_POST['CustomerNotReached']; 
$Q1 = $_POST['Q1']; 
$Q2 = $_POST['Q2']; 
$Q3 = $_POST['Q3']; 
$Q4 = $_POST['Q4']; 
$Q5 = $_POST['Q5']; 
$Comments = $_POST['Comments']; 
$HAPPY = $_POST['HAPPY']; 
$Deactivate = $_POST['Deactivate'];
$Comments2 = $_POST['Comments2'];

mysql_connect(""); 
mysql_select_db(""); 
for($i = 0; $i < count($RO); $i++)
	if($CustomerNotReached=='1'){
	$query = "UPDATE KEYCAD SET Hold='N', FollowUpContact='$FollowUpContact[$i]', CustomerNotReached='$CustomerNotReached[$i]', Q1='$Q1[$i]', Q2='$Q2[$i]', Q3='$Q3[$i]', Q4='$Q4[$i]', Q5='$Q5[$i]', Comments='$Comments[$i]', HAPPY='$HAPPY[$i]', Deactivate='$Deactivate[$i]', Comments2='$Comments2[$i]' WHERE RO='$RO[$i]'";
	}else{
	$query = "UPDATE KEYCAD SET Hold='Y', FollowUpContact='$FollowUpContact[$i]', CustomerNotReached='$CustomerNotReached[$i]', Q1='$Q1[$i]', Q2='$Q2[$i]', Q3='$Q3[$i]', Q4='$Q4[$i]', Q5='$Q5[$i]', Comments='$Comments[$i]', HAPPY='$HAPPY[$i]', Deactivate='$Deactivate[$i]', Comments2='$Comments2[$i]' WHERE RO='$RO[$i]'";
	}
print $query."<br />"; 
$result = mysql_query($query) or die(mysql_error());
echo"Thank You! Information Updated.\n";

?>