need help creating an update section

[mikewooten]

i am working on an administration section. i need help creating an edit/update page where i click the update link on a showproducts.php page, and that link goes to an updateproducts.php page where i can fill out a form on that updateproducts.php page then when i click on the submit button, it updates that product. The information that i would like to update is the category ID, Item ID, Product Item, Item Name, Item Image, Item Description and Item Price.
so far all that i have is just the form, i need help creating the php code for this to work.

is there anyone that can help me out with this, much help would be appreciated.
thanks

[devinemke]

the basic idea:
1. on showproducts.php pull the data of the db (perhap based on a passed GET var) and stick in a session. provide a link to updateproducts.php.
2. on updateproducts.php pull that same data out of the session and stick in to the name/value tags of a form
3. when the form is submitted contruct an UPDATE query based on the POSTed data and run the query

[mikewooten]

i'm trying to understand what your saying here:
so..
pull the data of the db and stick in a session -
would that be something like this $row['itemName']

then would the link be a php link like
<a href="edit1.php?id='.$row['catid'].'">edit</a>
i need for the link to display each row number when the link is rolled over. ex. when you rollover the link, the row ID number needs to show up link.

then
pull that same data out of the session and stick in to the name/value tags of a form

would that be something like this

echo('<form action="edit.php" method="post">');
echo('Item Name: <input type="text" name="itemName" value="'.$row['itemName'].'"><br />');
echo('<input type="submit" name="submit" value="submit">');
echo('</form>');

then the update query would be something like
$query="UPDATE * FROM $tblname";

would any of that be right, if not can you help me out to understand this?
thanks

[mikewooten]

i have this code on the showprod4.php page, where could i add addslashes() and stripslashes()?
could someone help me out with this?
thanks
here's the code:

<?
require_once('book_sc_fns.php');
session_start();
do_html_header('Administration');

$dbname = "mwooten1_rmgiusa"; 
$tblname = "items"; 
$linkid = mysql_connect("localhost", "username", "password") or die("Couldn't connect.");  

$db = mysql_select_db($dbname, $linkid) or die("Couldn't select database."); 
mysql_query ("SELECT * FROM $tblname"); 
echo "$select<br>";            

    $host    ="localhost";
    $dbuser="username";
    $dbpass="password";
    $database="mwooten1_rmgiusa";                

mysql_connect($host,$dbuser,$dbpass);
mysql_select_db($database) or die ("Unable to select database");    

$query="SELECT * FROM $tblname ORDER BY itemId ASC";  

$num=mysql_num_rows($result);  

$result = mysql_query($query, $linkid);   

include("include_code5.php");  

echo "<table border='1' bordercolor='#000000' cellpadding='0' cellspacing='0' width='100%'>";  

echo "<tr>";
echo "<td width='5%'><strong><center>cat id</center></strong></td>";
echo "<td width='6%'><strong><center>item id</center></strong></td>";
echo "<td width='10%'><strong><center>product item</center></strong></td>"; 
echo "<td width='10%'><strong><center>item name</center></strong></td>"; 
echo "<td width='20%'><strong><center>item image</center></strong></td>";
echo "<td width='30%'><strong><center>item desc</center></strong></td>";
echo "<td width='14%'><strong><center>item price</center></strong></td>";
echo "<td width='5%'><strong><center>Delete</td>";
echo "<td width='5%'><strong><center>Update</td>";
echo "</tr>";
while($query_data = mysql_fetch_row($result)) {
echo "<tr>";
echo "<td>$query_data[0]</td>";
echo "<td>$query_data[1]</td>";
echo "<td>$query_data[2]</td>"; 
echo "<td>$query_data[3]</td>";
echo "<td><img src='../p_imgs/$query_data[4]'></td>";
echo "<td>$query_data[5]</td>";
echo "<td>$query_data[6]</td>";
echo "<td>";
?>
deleterow
<?
echo "</td>";
echo "<td>";
echo('<table border="1"><tr><td><a href="edit2.php?id='.$query_data[1].'">edit'.$row['catid'].'</a></td><td>'.$row['itemName'].'</td><td>'.$row['itemDesc'].'</td><td>'.$row['temPrice'].'</td><td>'.$row['ItemImage'].'</td></tr></table>');
echo "</td>";
echo "</tr>";
}     

echo "</table>";  

do_html_footer();
?>

[mikewooten]

i need a confirm link on the showprod4.php page that when clicked takes me to another page (a confirmation page) where that page shows me that one row of information from the showprod4.php page on that confirmation page. then on the confirmation page i have the option to delete that one row or go back to the show products page.
can anyone help me out with this
any help would be much appreciated
thanks

the code that i have for showprod4.php page is:

<?
require_once('book_sc_fns.php'); 
session_start();
do_html_header('Administration');

$dbname = "mwooten1_rmgiusa"; 
$tblname = "items"; 
$linkid = mysql_connect("localhost", "username", "password") or die("Couldn't connect.");  

$db = mysql_select_db($dbname, $linkid) or die("Couldn't select database."); 
mysql_query ("SELECT * FROM $tblname"); 
echo "$select<br>";			
	$host    ="localhost";
	$dbuser="username";
	$dbpass="password";
	$database="mwooten1_rmgiusa";				
mysql_connect($host,$dbuser,$dbpass);
mysql_select_db($database) or die ("Unable to select database");    

$query="SELECT * FROM $tblname ORDER BY itemId ASC";  

$num=mysql_num_rows($result);  

$result = mysql_query($query, $linkid);   

include("include_code5.php"); 

echo "<table border='1' bordercolor='#000000' cellpadding='0' cellspacing='0' width='100%'>";  

echo "<tr>";
echo "<td width='5%'><strong><center>cat id</center></strong></td>";
echo "<td width='6%'><strong><center>item id</center></strong></td>";
echo "<td width='10%'><strong><center>product item</center></strong></td>"; 
echo "<td width='10%'><strong><center>item name</center></strong></td>"; 
echo "<td width='20%'><strong><center>item image</center></strong></td>";
echo "<td width='30%'><strong><center>item desc</center></strong></td>";
echo "<td width='14%'><strong><center>item price</center></strong></td>";
echo "<td width='5%'><strong><center>Delete</td>";
echo "<td width='5%'><strong><center>Update</td>";
echo "</tr>";
while($query_data = mysql_fetch_row($result)) {
echo "<tr>";
echo "<td>".stripslashes($query_data[0])."</td>";
echo "<td>".stripslashes($query_data[1])."</td>";
echo "<td>".stripslashes($query_data[2])."</td>"; 
echo "<td>".stripslashes($query_data[3])."</td>";
echo "<td><img src='../p_imgs/$query_data[4]'></td>";
echo "<td>".stripslashes($query_data[5])."</td>";
echo "<td>".stripslashes($query_data[6])."</td>";
echo "<td>";
?>
deleterow
<?
echo "</td>";
echo "<td>";
echo('<table border="1"><tr><td><a href="edit2.php?id='.$query_data[1].'">edit'.$row['catid'].'</a></td><td>'.$row['itemName'].'</td><td>'.$row['itemDesc'].'</td><td>'.$row['temPrice'].'</td><td>'.$row['ItemImage'].'</td></tr></table>');
echo "</td>";
echo "</tr>";
}     

echo "</table>";  

do_html_footer();
?>