[SOLVED] mysql edit update

[justAnoob]

I will be back tomorrow guys,,,, I'm getting tired... Thanks for all the help though... I'll start again tomorrow... I just hope everthing we did will still help in the long run....

[justAnoob]

Well Ken2K7,, you helped me out yesterday with a variable on a script. So now my paginatio setup is done for each user that has more than one picture on their account....So now I'm back to getting this Update button to work....With the pagination setup,, the update button appears for each picture... When I click on the update button, it echos that the item has been updated. But then I refresh my page and nothing has actually been changed.... Here is the form page and the update script.... I got to go outside and cut the grass,,, so I'll be back later...

<form id="form2" name="form2" method="post" action="update.php">
<?php
session_start();
include "connection.php";
if (isset($_GET['pageno']))
{
  $pageno = $_GET['pageno'];
}
else
{
  $pageno = 1;
}
$findit = $_SESSION['id'];
$result = mysql_query("SELECT id FROM members WHERE username = '$findit' LIMIT 1");
$e_row = mysql_fetch_assoc($result);
$query = mysql_query("SELECT count(*) FROM abcxyz WHERE user_id = " . $e_row['id']) or die(mysql_error());


$query_data = mysql_fetch_row($query);
$numrows = $query_data[0];
$rows_per_page = 1;
$lastpage = ceil($numrows/$rows_per_page);
$pageno = (int)$pageno;
$prevpage = $pageno-1;
$nextpage = $pageno+1;


if ($pageno > $lastpage)
{
  $pageno = $lastpage;
}
if ($pageno < 1)
{
  $pageno = 1;
}
$limit = 'LIMIT ' .($pageno - 1) * $rows_per_page .',' .$rows_per_page;

$sql = mysql_query("SELECT id, imgpath, imgpath2, imgpath3, imgpath4, imgpath5, item_name, description, in_return FROM abcxyz WHERE user_id = " . $e_row['id'] . " $limit");   
if($lastpage != 0)
{
echo "<table width='954' border='0' align='center' cellpadding='0' cellspacing='0' bordercolor='#000000' bgcolor='#BBD4E1'>";
while ($row = mysql_fetch_array($sql))
{
echo "<tr><td width='188' height='180'><div align='center'>";
echo '<img src="' . $row['imgpath'] . '" width="125" alt="" />';
echo "</div></td><td width='188'><div align='center'>";
echo '<img src="' . $row['imgpath2'] . '" width="125" alt="" />';
echo "</div></td><td width='188'><div align='center'>";
echo '<img src="' . $row['imgpath3'] . '" width="125" alt="" />';
echo "</div></td><td width='188'><div align='center'>";
echo '<img src="' . $row['imgpath4'] . '" width="125" alt="" />';
echo "</div></td><td width='190'><div align='center'>";
echo '<img src="' . $row['imgpath5'] . '" width="125" alt="" />';
echo "</div></td></tr><tr><td height='43' colspan='4'>";
echo '<strong>Item Name:</strong> <input type="text" name="item_name" value="' . $row['item_name'] . '" size="50" />   ';
if ($pageno == 1)
{
  echo " Previous Item ";
}
else
{
  echo "<a href='{$_SERVER['PHP_SELF']}?pageno=$prevpage'> Previous Item </a>";
}
echo "($pageno of $lastpage)";
if ( $pageno == $lastpage )
{
  echo " Next Item ";
}
else
{
  echo "<a href='{$_SERVER['PHP_SELF']}?pageno=$nextpage'> Next Item </a>";
}
echo "</td><td><div align='center'>";
echo "";
echo "</div></td></tr><tr><td height='116' colspan='4'>";
echo '<strong>Description:</strong> <textarea name="description" cols="75" rows="5">' . $row['description'] . '</textarea>';
echo "</td><td><div align='center'>";
echo "</div></td></tr><tr><td height='124' colspan='4'>";
echo '<strong>Seeking:</strong>       <textarea name="in_return" cols="75" rows="5">' . $row['in_return'] . '            </textarea>';
echo "</td><td><div align='center'>";
echo '<input type="submit" name="submit" id="submit" value="Update">';
echo "</div></td></tr><tr><td colspan='4'>";
echo '';
echo "</td><td><div align='center'>";
echo '';
echo "</td></tr>";
}
echo "</table>";
}
else
{
  echo "You currently have no pics.";
}
?>

</form>

<?php
error_reporting(E_ALL);
ini_set('display_errors',1);
session_start();
require 'connection.php';
if(isset($_POST['submit']))
{
  $item_name = mysql_real_escape_string($_POST['item_name']);
  $description = mysql_real_escape_string($_POST['description']);
  $in_return = mysql_real_escape_string($_POST['in_return']);
  $sql = "UPDATE member_trades SET item_name = '$item_name', description = '$description', in_return = '$in_return' WHERE id = '1'";  //right now just putting in id number until script works,, then I'll put in the variable.
  if(mysql_query($sql))
  {
     echo $item_name . ' has been updated.';
  }
  else
  {
     echo 'There was an error processing the query: ' . mysql_error();
  }
}
?>

 

Be back in a couple hours...

[Ken2k7]

Put a hidden field for the item id so when the form submits, update.php can get the item id.

[justAnoob]

I placed a hidden field on the form... Created a session variable for $row['id'].....Then called that variable on the update script and everything works great.. Would you do anything different????

[Ken2k7]

What's wrong with just $_POST data instead of $_SESSION data?

[justAnoob]

True true,,,, I guess thinking too much is bad sometimes...LoL... Thanks for all the help bud.