Natali25
-
Posts
1 -
Joined
-
Last visited
Never
Natali25's Achievements
Newbie (1/5)
0
Reputation
-
Hi everybody, Here is the code for creating a website,please have a look on the attachment(It shows how my web page looks like).I have 3 forms in each row and I have almost 2000 rows. 1)my problem is whenever I choose an option from one of the forms,It shows the result for the whole coulmns (example :If I choose passed on the first row and I click submit ,It shows passed for the all the rows in this column) So please help me if you can give me a script that it works properly. 2)Also I have another problem.my problem is each form works seprately from the other.I mean I can not see the result of 3 forms together.it does not save the result from the previous column? <html> <head> </head> <body> <font size="6"> <?php $db_host ="localhost"; $db_username ="***"; $db_pass ="****"; $db_name ="****"; @mysql_connect("$db_host","$db_username","$db_pass") or die ("Could not connect to mySQL"); @mysql_select_db("$db_name") or die ("No database"); $sql ="SELECT * FROM `item_shop`"; //Select everything from the Database Where the columt Id = $id $result = mysql_query($sql); echo "<table border='1' width='100%' align='center' cellpadding='6' cellspacing='1' bgcolor='#CCCCCC' class='font_2'>"; //Begin of the Table ?> <tr align="center" valign="middle"> <td width="6%" bgcolor="#FFA07A" ><a href="?order=orgobjid&account_id=&send=send&keytype=GUID&keyword=&seq=desc">ID</a></td> <td width="12%" bgcolor="#FFA07A" >Name</td> <td width="1%" bgcolor="#FFA07A" >Stacked Number:\32</td> <td width="32%" bgcolor="#FFA07A" >Description</td> <td width="6%" bgcolor="#FFA07A" >Type </td> <td width="20%" bgcolor="#FFA07A" >Used Type</td> <td width="8%" bgcolor="#FFA07A" >Verification</td> <td width="8%" bgcolor="#FFA07A" >Item Flag</td> <td width="40%" bgcolor="#FFA07A" >Test Comment</td> </tr> <?php while($row = mysql_fetch_array($result)) { ?> <td width="6%" bgcolor="#FFDEAD" ><a href="?order=orgobjid&account_id=&send=send&keytype=GUID&keyword=&seq=desc"><?php echo $row['ID']; ?></a></td> <td width="12%" bgcolor="#FFDEAD" ><?php echo $row['Name']; ?></td> <td width="1%" bgcolor="#FFDEAD" ><?php echo $row['Stacked_Number']; ?></td> <td width="32%" bgcolor="#FFDEAD" ><?php echo $row['Description']; ?></td> <td width="6%" bgcolor="#FFDEAD" ><?php echo $row['Type']; ?> </td> <td width="20%" bgcolor="#FFDEAD" ><?php echo $row['Used_Type']; ?></td> <td align="center" bgcolor="#FFDEAD"> <form method="post" action="http://****.php""> Test Result? <select name="Choose One"> <option>Choose One</option> <option>Passed</option> <option>Blocked</option> <option>Retest</option> <option>Failed</option> </select><br> <input type="submit" value="Submit"> <td align="center" bgcolor="#FFDEAD"> </form> <form method="post" action="http://*****.php"> Item Flag? <select name="degree"> <option>Choose One</option> <option>Item Shop</option> <option>Phirius Tocken Shop </option> <option>Both</option> </select> <br><input type="submit" value="Submit"> </form> <td align="center" bgcolor="#FFDEAD"> <form method="post" action="http://****.php"> <textarea rows="5" cols="20" wrap="physical" name="comments"> <?php echo $row['Test_Comment']; ?> </textarea><br> <input type="submit" value="Submit"> <input type="reset" value="Reset"> </form> <td align="center" bgcolor="#FFDEAD"> <table border="1"> <tr><td> <form name="Form1" method="POST" action="http://***.php"> <br/> <textarea name="txtMessage" cols="30" rows="4"></textarea> <br /> <input type="submit" name="Submit" value="Submit" /> <input type="reset" name="Submit2" value="Reset" /> </p> </form> </td></tr> </table> <pre> <? echo $_POST['txtMessage']; ?> </pre> </p> <?php echo "</tr>"; } echo "</table>"; //End of the Table ?> </body> </html>
