update problem ! is this Mysql BUG ?

[Anon]

hi all
i have problem when i wanna update some data in the mysql, here is the code :

____________________________________________

   #####################################
   #       Adding sub catagory         #
   #####################################


if ($action  == "addsubcat") {
?>

<form method="POST" action="<?=$PHP_SELF;?>?action=newsubcat">
<input type="hidden" name="cat" value="1">
<div align="center">
<center>
<table border="0" cellspacing="1" cellpadding="3" class="table_border">
<tr>
<td colspan="2" class="header_cell">
<p align="center">.:: Add Sub Catagory ::.</p>
</td>
</tr>

<!-- ##################### -->

<tr>
<td align="right" class="cells">Name :</td>
<td class="cells"><input class="box" type="text" name="subcatname" size="30"></td>
</tr>

<tr>
<td align="right" class="cells"> Sorting In Catagory :</td>
<td class="cells">
<?
/*
##################################
##### make Catagory List #########
##################################  */
$sql_cat="select * from catagory";
$result_cat=@mysql_query($sql_cat,$db);

echo "

  <select name=\"catagory\">
  ";
          while($mycat=@mysql_fetch_array($result_cat))
	{
$catagory_id=$mycat["catagory_id"];
$catagory=$mycat["catagory"];


  echo"<option value=\"$catagory\">$catagory_id . $catagory</option>";
}
echo"</select>";?>


</td>
</tr



<tr>
<td colspan="2" class="header_cell">
<p align="center"><input type="submit" name="submit">
</td></tr>

</div>
</table>

  <font color="#ff6600"> <? $result = mysql_query("select * from sub_cat");
 $num = mysql_num_rows($result);
 echo "<br><b>:: The are $num sub catagory now ::</b><br>";?>

 <br>
<table border="0" cellspacing="1" cellpadding="3" class="table_border">
<div align="center">
<tr ><td class="header_cell">ID </td>
<td class="header_cell"> Name</td>
<td class="header_cell"> Catagory</td>

<td class="header_cell">Del Sub</td>


</tr>

  <?
          $sql_cat="select * from sub_cat order by sub_cat_n";
$result_cat=@mysql_query($sql_cat,$db);

      while($mycat=@mysql_fetch_array($result_cat))
{
$sub_cat_id=$mycat["sub_cat_id"];
$sub_cat_n=$mycat["sub_cat_n"];
$catagory=$mycat["catagory"];


 ?>
 <tr><td class="cells">
<?=$sub_cat_id;?></td><td class="cells">

<a href="<? echo "$PHP_SELF?action=renamesubcat&sub_cat_n=$sub_cat_n"; ?>">
<?=$sub_cat_n;?></a>
</td>

<td class="cells">
<font color="#cef0066"><?=$catagory;?>

</td>


</td>
<td class="cells">
<a href="<?echo"$PHP_SELF?action=delcom&company_id=$company_id";?>"><img src="del2.gif" border=0 alt="Delete  <?=$company?>"></a>
    </td>

</tr>

<?}}?>
 </center>
</table>
</center>
</div>



<?         ##############adding new sub catagory function !

if($action == "newsubcat" && $cat == "1"){
if ($subcatname == ""){
      echo "<center><font color=\"#ff0000\"> you must write the sub catagory name!<br>";
      echo"<a href=\"javascript:history.back(-1);\">Back</a>";
  }else {

  $query = "INSERT INTO sub_cat (sub_cat_id, sub_cat_n, catagory)
 VALUES ('', '$subcatname', '$catagory')";

		mysql_query($query, $db);


   echo"<center>New sub catagory added with name <font color=\"#ff6600\"><b>$subcatname$b</center>";
     }
}


##################### rename SUBCATAGORY !


if ($action  == "renamesubcat") {

?>

<form method="POST" action="<?=$PHP_SELF;?>?action=resubcat">
<input type="hidden" name="recat" value="1">
<div align="center">
<center>
<table border="0" cellspacing="1" cellpadding="3" class="table_border">
<tr>
<td colspan="2" class="header_cell">
<p align="center">.:: Rename Sub Catagory <font color="#ff6600"><?=$sub_cat_n;?></font> ::.</p>
</td>
</tr>

<!-- ##################### -->

<tr>
<td align="right" class="cells">Name :</td>
<td class="cells"><input class="box" type="text" name="sub_cat_n1" size="30" value="<?=$sub_cat_n;?>"></td>
</tr>

<tr>
<td align="right" class="cells"> Sorting In Catagory :</td>
<td class="cells">
<?
/*
##################################
##### make Catagory List #########
##################################  */
$sql_cat="select * from catagory";
$result_cat=@mysql_query($sql_cat,$db);

echo "

  <select name=\"catagory1\">
  ";
          while($mycat=@mysql_fetch_array($result_cat))
	{
$catagory_id=$mycat["catagory_id"];
$catagory=$mycat["catagory"];


  echo"<option value=\"$catagory\">$catagory_id . $catagory</option>";
}
echo"</select>";?>


</td>
</tr



<tr>
<td colspan="2" class="header_cell">
<p align="center"><input type="submit" name="submit">
</td></tr>

</div>
</table>
<?}
if($action == "resubcat" ){

if ($sub_cat_n1==""){
    echo "<center><font color=\"#ff0000\"> you must write the new sub catagory name!<br>";
    echo"<a href=\"java script:history.back(-1);\">Back</a>";
}
else{
    $sql = "update sub_cat set sub_cat_n='$sub_cat_n1', catagory='$catagory1' where sub_cat_n='$sub_cat_n'";
    $result = mysql_query($sql,$db);

    if(!$result){
        echo mysql_error();
    }
    else{
        echo"<center>Rename sub catagory to<font color=\"#ff6600\"> $sub_cat_n1</font>, has been done$b</center>";
    }
}
}


?>
__________________________________________

after updating i got msg it`s ok, and no mysql_error !

PLZ HELP ME !!!!!!!!!!!

[Anon]

IS IT HOPLESS ?!?!?!

[Anon]

any1 PLEASE !

[Anon]

PLZ HELP !
the code is right, but wan`t update !!!!
WHAY 🙁(((

Richi wrote:

any1 PLEASE !

[Anon]

I'd Love to look at it but I am color blind and the last script practicaly disapears because of the colors, Sory

[Anon]

Here is a clip Right out of the php manual.

mysql_query() returns TRUE (non-zero) or FALSE to indicate whether or not the query succeeded. A return value of TRUE means that the query was legal and could be executed by the server. It does not indicate anything about the number of rows affected or returned. It is perfectly possible for a query to succeed but affect no rows or return no rows.

This Means that in you update statement you will always have a result if your code is good, but the update fails so the
if(!$result){ statement should not work anyway. Perhaps if you checked for the number of rows effected using the mysql_afeected_rows() function. You can find information on that here: http://www.php.net/manual/en/function.mysql-affected-rows.php
I am assuming, of course, that you are refering to this section of the code:

$sql = "update sub_cat set sub_cat_n='$sub_cat_n1', catagory='$catagory1' where sub_cat_n='$sub_cat_n'";
$result = mysql_query($sql,$db);

if(!$result){
echo mysql_error();
}
else{
echo"<center>Rename sub catagory to $sub_cat_n1, has been done$b</center>";
}

Hope I helped, if not, I am prety new to programming so forgive me.
ALfred

[Anon]

i`ll write book about this problem !!

the same code am using it with another vars. to updata another teble, and it`s work as i need !!

please HELP ME !!!!!!!!!!!

for more please check this link, there more than 50 post about this no one know whay ?!

http://www.sitepointforums.com/showthread.php?s=&postid=220279&t=4218#post220279

[Anon]

$sql = "update subcat set sub_cat='$sub_cat1', catagory='$catagory1' where sub_cat='$sub_cat'";
$result = mysql_query($sql, $db);

echo (mysql_affected_rows()?"success":"failure");

---

i got failure !

[Anon]

HURAAAAAAAAAAAAAAAAAAAAAAAAA !!

i was so DUMB , i know now whay didn`t work

---

$query = mysql_query("Select * from subcat ",$db);
list($sub_cat_id, $sub_cat, $catagory) = mysql_fetch_row($query);

---

that`s whay !!!

it`s take 3 day to do it