Please help!!!

[yousamook]

hi everyone!

 

So i need to get a users input from my form so i created a table with PHP that basically throws out the information and creates multiple positions in that table. the code i used was this:

 

<?php 
                               	$exit = "<table border=0 ><tr><td align=left colspan=600>";
                              	$exit .= "<tr>
                                          <td ><span class=underline>Description</span></td>
                                          <td ><span class=underline>Date Received</span></td>
                                          <td ><span class=underline>Date Issued</span></td>
                                          <td ><span class=underline>Date Expired</span></td>
                                          <td ><span class=underline>Certificate or License Number</span></td>
                                      </tr>";
                          
                      
								  $db = new dbConnection();
								  $db->dbConnect();
								  $db->dbSelect();
                      
							$query_doc = "	select 	dt.uniqueid, dt.description ,
												formatDate(pd.date_received) as date_received, 
												formatDate(date_inservice) as date_inservice, 
												formatDate(date_expired) as date_expired,
												license 
										from 	document_types dt 
												left join personnel_document pd on 
													(pd.doc_type = dt.uniqueid and pd.empnum = $EmpNum)
										order by 2";

							$ds = mssql_query($query_doc);

							$exit .= "<input type=hidden value='" . mssql_query($ds). "' id=ciclos name=ciclos>";
	  						
                          		
		         				$position = 1;      
                                           
                         		
		 					while ($row = mssql_fetch_array($ds)) {
                      
                                extract($row);
                                  
                                          
                                $exit .= "<tr>
                                              <td><span class=doc_style><label for = description$position> $description</label></span></td>
                                              <td><input type=text name= date_received$position id= date_received$position size=15 value= '$date_received' ></td>
                                              <td><input type=text name = date_inservice$position id= date_inservice$position value= ' $date_inservice' size=15></td>
                                              <td><input type=text name= date_expired$position id= date_expired$position value= ' $date_expired' size=15></td>
                                              <td><input type=text name = license id= license value= ' $license' size=30></td>						
                                          </tr>";
                          		$position++;
					  
						  	} 
                      
                          		$exit .= "</td></tr></table>";
                          
							echo $exit;
                              
                      ?>

 

now what that does if you do a :

 

$keys = array_keys($_POST);	
$values = array_values($_POST);

for ($i = 0; $i <= count($keys); $i++)
	echo "{$keys[$i]} = {$values[$i]} <br>";

 

is take out the information from the post and number it from 1 to 15 as show here :

 

^{date_received1 =}

^{date_inservice1 =}

^{date_expired1 =}

^{license1 =}

^{date_received2 =}

^{date_inservice2 =}

^{date_expired2 =}

^{license2 =}

^{date_received3 =}

^{date_inservice3 =}

^{date_expired3 =}

^{license3 =}

^{date_received4 =}

^{date_inservice4 =}

^{date_expired4 =}

^{license4 =}

^{date_received5 =}

^{date_inservice5 =}

^{date_expired5 =}

^{license5 =}

^{date_received6 =}

^{date_inservice6 =}

^{date_expired6 =}

^{license6 =}

^{date_received7 =}

^{date_inservice7 =}

^{date_expired7 =}

^{license7 =}

 

^etc.....

 

I need to make an update statement to update my MS SQL with the user input but not sure how to do it... I dont want to do 15 different updates.... does anyone know a better way to get ths information into an update statement?

 

 

Someone please help me with this issue!

:confused: