jd| Posted August 20, 2006 Share Posted August 20, 2006 Hi all This has been driving me crazy for a few days no matter what I do I can't get the result I want. I have a table with a form on it. the form is loop for the number off Members (in my test this is 7)and the user enters a score for each member.The form then passes the data to a new page for proccessing. This is where it all falls to pieces.I can see the data in the address bar but when I try any loop I can only ever display the last results.the output should be Mem=1 test = aMem=2 test = bMem=3 test = c etc...Data being passed using "get" function on the form page. show.php?Mem=1&point=a&Mem=2&point=b&Mem=3&point=c&Mem=5&point=d&Mem=6&point=e&Mem=7&point=fAny ideas ?Thanks JD Quote Link to comment Share on other sites More sharing options...
hitman6003 Posted August 20, 2006 Share Posted August 20, 2006 In the $_GET array, because you are using the same variable name for each one of your members, it will overwrite it, so you end up with only the last one.Try naming your inputs Mem[] and point[], which will create subarrays for each in the $_GET array. Quote Link to comment Share on other sites More sharing options...
jd| Posted August 24, 2006 Author Share Posted August 24, 2006 I have tried everything I know and I always get the last result in the table no matter what I do. Any other suggestions ?JD Quote Link to comment Share on other sites More sharing options...
ronverdonk Posted August 24, 2006 Share Posted August 24, 2006 Show your code, then at least we all see what you are talking about!Ronald 8) Quote Link to comment Share on other sites More sharing options...
jd| Posted August 24, 2006 Author Share Posted August 24, 2006 Hi I have tried several various ways of getting this to work and the, script to show it uses the "foreach" array but will not work !its the $array[array] thats causing the problem. The data entered in the form can be any interger value. and the table/ form is variable depending on the number of members in the database.ThanksJD[code]$list = "<table border =\"1\"><tr><th>Forename</th>";$list.= "<th>Surname</th>";$list.= "<th>Handicap</th>";$list.= "<th>Edit</th>";$list.= "<th>Points</th></tr>";$form ="<form action=\"show.php\" ";$form.= "method =\"get\">"; while ($row= mysql_fetch_array($rs) ) { $array = array('point'==$value); $Mem = $row["Mem_Id"]; $list.= "<tr>"; $list.= "$test1"; $list.= "<td>".$row["Forename"]."</td>"; $list.= "<td>".$row["Surname"]."</td>"; $list.= "<td>".$row["Hcap"]."</td>"; $list.= "<td> <input type=\"text\" name=\"Mem\" value=\"$Mem\"> </td>"; $list.= "<td> <input type=\"text\" name=\"array\" value=\"$array[array]\"> </td>"; }$list.= "</table>";echo ($list); $form.= "<input type=\"submit\" value=\"Submit\">"; $form.= "</form>"; echo($form);?>[/code] Quote Link to comment Share on other sites More sharing options...
craygo Posted August 24, 2006 Share Posted August 24, 2006 first of all your $list and $form are screwed up. If you look at the page and right click and select view source, you will see that you end up listing the form tag twice in which case you cancel out the first form tag. redo your form and try thatRay Quote Link to comment Share on other sites More sharing options...
jd| Posted August 25, 2006 Author Share Posted August 25, 2006 Thanks Ray cleaned the code up for the form. Never even noticed it was doing that cause of the loop had been playing about with it so much to get the form to display properly.Still no luck with getting the data the result from the form is...[code]show.php?Mem=1&array=a&Mem=2&array=b&Mem=3&array=c&Mem=5&array=d&Mem=6&array=e&Mem=7&array=f[/code]And the below is the form page...[code]$list = "<table border =\"1\"><tr><th>Forename</th>";$list.= "<th>Surname</th>";$list.= "<th>Handicap</th>";$list.= "<th>Edit</th>";$list.= "<th>Points</th></tr>";$list.="<form action=\"show.php\" ";$list.="method =\"get\">";while ($row= mysql_fetch_array($rs) ){$Mem = $row["Mem_Id"];$list.= "<tr>";$list.= "<td>".$row["Forename"]."</td>";$list.= "<td>".$row["Surname"]."</td>";$list.= "<td>".$row["Hcap"]."</td>";$list.= "<td> <input type=\"text\" name=\"Mem\" value=\"$Mem\"> </td>";$list.= "<td> <input type=\"text\" name=\"array\" value=\"$array[array]\"> </td>";} $list.= "</table>";$list.= "<input type=\"submit\" value=\"Submit\">";$list.= "</form>"; echo($list);?>[/code] Quote Link to comment Share on other sites More sharing options...
jd| Posted August 27, 2006 Author Share Posted August 27, 2006 Anyone else have any ideas as to where I'm going wrong with this one ?Thanks JD Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.