data updating problem, any1 know ?!

[lynlimz]

Originally posted by Richi


ok, but i didn`t put any code which assigns value to sub_cat, coz it`s take from sub_cat1 !

hmm...huh? so if its taken from $sub_cat1, did you do something like

$sub_cat = $sub_cat1;

??????
else how is the script going to find which row has sub_cat equals $sub_cat when $sub_cat is empty???

[Richi]

did u get the email ?

[Richi]

<input class="box" type="text" name="sub_cat1" 
size="30" value="<?=$sub_cat;?>">
..
..
..
$sql = "update subcat set sub_cat='$sub_cat1', 
catagory='$catagory1' where sub_cat='$sub_cat'";
$result = mysql_query($sql, $db);

i think this right, or not ?

[seanf]

$catagory_id=$mycat["catagory_id"]; 

You have not got a field called catagory_id in your table, is it supposed to be catagory?

Sean

[Richi]

here am postin to function, the first to add, rename, delete field with name company, and the another function for the sub catagory (sub_cat) with the same option :

######################################
##     Adding New Company           ##
######################################

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

<form method="POST" action="<?=$PHP_SELF;?>?action=newcompany">
<input type="hidden" name="newcom" 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 Company ::.</p>
</td>
</tr>

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

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

<tr>
<td align="right" class="cells"> 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 company");
 $num = mysql_num_rows($result);
 echo "<br><b>:: The are $num company 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"> Company Name</td>
<td class="header_cell"> Artical No.</td>
<td class="header_cell"> Company Type</td>

<td class="header_cell">Del. Link</td>


</tr>

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

          while($mycat=@mysql_fetch_array($result_cat))
    {
$company=$mycat["company"];
$company_id=$mycat["company_id"];
$catagory=$mycat["catagory"];

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

<a href="<?php echo "$PHP_SELF?action=renameco&company=$company"; ?>">
<?=$company;?></a>
</td>
<td class="cells">
<font color="#cef0066">
<?$result = mysql_query("select * from $table where company_id='$company_id'");
 $num = mysql_num_rows($result);
 echo "<b>$num</b>";?>

</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>

 
 
 
 
<?}
########## inserting the new co. name into db.

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

  $query = "INSERT INTO company (company_id, company, catagory)
 VALUES ('', '$company', '$catagory')";

            mysql_query($query, $db);


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

################ deleting company !

if ($action == "delcom"){

    $sql="select * from company where company_id=$company_id";
    $result=@mysql_query($sql,$db);
    $myrow=@mysql_fetch_array($result);
    $company=$myrow["company"];
    $company_id=$myrow["company_id"];


echo"<center>Are you sure you want to delete
<font color=\"#ff4400\"><b> ".$company."  </font></b> ?<br>
<a href=\"?action=deletecom&company_id=$company_id\">YES</a> | <a href=\"panel.php\">NO</a>
<br> This will delete all the company artical !</center>";
}
if ($action == "deletecom"){
           $sql="delete from company where company_id='$company_id'";
           $result=mysql_query($sql,$db);

           $sql1="delete from $table where company_id='$company_id'";
           $result1=mysql_query($sql1,$db);

echo "<center> Company & all the artical deleted ! $b";
}


             ####################
             # Rename co. name  #
             ####################


               
if ($action == "renameco"){

    ?>

<form method="POST" action="<?echo"$PHP_SELF?action=renamecomp&company=$company";?>">
<input type="hidden" name="recomp" value="1">
<div align="center">

<table border="0" cellspacing="1" cellpadding="3" class="table_border">
<tr>
<td colspan="2" class="header_cell">
<p align="center">.:: Rename Company <font color="#ff6600"><?=$company;?></font> ::.</p>
</td>
</tr>
<!-- ##################### -->
<tr>
<td align="right" class="cells">New  Name :</td>
<td class="cells"> <?=$company_id;?>::
<input class="box" type="text" name="company1" size="30" value="<?=$company;?>"></td>

</tr>




<tr><td class="cells"> Move it to cat.</td>
<td class="cells">
<?
$sql_cat="select * from catagory";
$result_cat=@mysql_query($sql_cat,$db);

echo "

  <select name=\"newcat\">
  ";
          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>";?>
  </tr></td>

<tr>
<td>
<p align="center"><input type="submit" name="submit">
</tr></td>
</table>
 </div>
 </form>


<?}

if($action == "renamecomp" && $recomp == "1"){
if ($company1 == ""){
      echo "<center><font color=\"#ff0000\"> you must write the new link name!<br>";
      echo"<a href=\"javascript:history.back(-1);\">Back</a>";
  }else {

   $sql = "update company set  company='$company1', catagory='$newcat' where company='$company'";
   $result=mysql_query($sql,$db);


   echo"<center>Rename company [ $company ] to<font color=\"#ff6600\"> $company1</font>, has been done$b</center>";
     }

}

this one it`s work as i want, and with the same command i made function for the sub catagory which wan`t work , just adding, but to rename, or to update it is not working :

       #####################################
       #       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 subcat");
 $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 subcat order by sub_cat ";
$result_cat=@mysql_query($sql_cat,$db);

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


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

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

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

</td>


</td>
<td class="cells">
<a href="<?echo"$PHP_SELF?action=delsubcat&sub_cat=$sub_cat";?>"><img src="del2.gif" border=0 alt="Delete  <?=$sub_cat?>"></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 subcat (sub_cat, 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;?></font> ::.</p>
</td>
</tr>

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

<tr>
<td align="right" class="cells">Name :</td>
<td class="cells">
<input class="box" type="text" name="sub_cat1" size="30" value="<?=$sub_cat;?>">
</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_cat1==""){
        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 subcat set sub_cat='$sub_cat1', catagory='$catagory1' where sub_cat='$sub_cat'";
$result = mysql_query($sql, $db);


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


    ?>

it`s the same cmd, but with another tables and field names !

[seanf]

What is the answer to my question?

I think the main problem is your where clause

Sean

[Richi]

there table with name catagory, include 2 field catagory and catagory_id, which will is listed in html select , when i need to rename the sub catagory name !

I`ILL WRITE A BOOK FROM THIS THERED !

[lynlimz]

Originally posted by seanf
What is the answer to my question?

I think the main problem is your where clause

Sean

wow. thanks. additional help. lol
yep..by illimination, WHERE clause is deifnitely the problem.
$sub_cat isn't returning a value.

and richi, i recieved your email. but i think there's no need to read it.
now..gotta read this carefully.

you declared your variable $sub_cat1 from your input fields. good. but you forgot to declare your $sub_cat variable. hence the reaosn why your WHERE clause is not working.

do you finally understand what i'm saying?

[lynlimz]

Originally posted by Richi
I`ILL WRITE A BOOK FROM THIS THERED !

but first..you gotta figure out your solution to your problem. as identified by my previous post.

[Richi]

almost i understand u from the start, but with same function i made it for company function, and i didn`t declared the variables !

but what u think, how can i declared variable $sub_cat1 ?

[Richi]

  ####################
             # Rename co. name  #
             ####################


               
if ($action == "renameco"){

    ?>

<form method="POST" action="<?echo"$PHP_SELF?action=renamecomp&company=$company";?>">
<input type="hidden" name="recomp" value="1">
<div align="center">

<table border="0" cellspacing="1" cellpadding="3" class="table_border">
<tr>
<td colspan="2" class="header_cell">
<p align="center">.:: Rename Company <font color="#ff6600"><?=$company;?></font> ::.</p>
</td>
</tr>
<!-- ##################### -->
<tr>
<td align="right" class="cells">New  Name :</td>
<td class="cells"> <?=$company_id;?>::
<input class="box" type="text" name="company1" size="30" value="<?=$company;?>"></td>

</tr>




<tr><td class="cells"> Move it to cat.</td>
<td class="cells">
<?
$sql_cat="select * from catagory";
$result_cat=@mysql_query($sql_cat,$db);

echo "

  <select name=\"newcat\">
  ";
          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>";?>
  </tr></td>

<tr>
<td>
<p align="center"><input type="submit" name="submit">
</tr></td>
</table>
 </div>
 </form>


<?}

if($action == "renamecomp" && $recomp == "1"){
if ($company1 == ""){
      echo "<center><font color=\"#ff0000\"> you must write the new link name!<br>";
      echo"<a href=\"javascript:history.back(-1);\">Back</a>";
  }else {

   $sql = "update company set  company='$company1', catagory='$newcat' where company='$company'";
   $result=mysql_query($sql,$db);


   echo"<center>Rename company [ $company ] to<font color=\"#ff6600\"> $company1</font>, has been done$b</center>";
     }

}

this one is work for rename the company`s name !
and it`s the same function for the sub catagorys!

[seanf]

He should be using sub_cat_id in the where clause, but he is not using it in his script.

This is making my head hurt

Some problems:

1) catagory_id does not exist in the table

2) update sub_cat set should be update catagory set

3) The sql_cat code does not work, should be something like this I think

$sql_cat = mysql_query("SELECT * FROM catagory") or die(mysql_error());

echo "<select name=\"catagory1\">";

while ( $mycat = mysql_fetch_array($sql_cat) ) {

extract($mycat);

echo"<option value=\"$catagory1\">$sub_cat_id . $catagory</option>";
}

echo"</select>"; 

But, the ID will not get sent this way.

Sorry if I am repeating anything you have said lynlimz

Sean

[lynlimz]

Originally posted by seanf
Sorry if I am repeating anything you have said lynlimz

Sean

not at all. i think i'll have a look at the entire scripthe sent me via email if its still not resolved.
i cna't seem to determine the overall structure of the script.

[Richi]

Originally posted by seanf
He should be using sub_cat_id in the where clause, but he is not using it in his script.

Some problems:

1) catagory_id does not exist in the table

2) update sub_cat set should be update catagory set

3) The sql_cat code does not work, should be something like this I think

i need to change the sub_cat, the name, so i used as value, and the sub_cat is uniq name, like the sub_cat_id !

the catagory_id is exist in another table, and when i update ill update the catagory in another tabel, subcat table !
there no problem with catagory`s selection, the problem in the subcat table, or in the where term !

[Richi]

another day, i think this the my thered day with this problem and now sulotion !!

[Richi]

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

THX ALOT TO ALL FOR UR TIME AND HELP !

[Richi]

GRRRRRRRrrrrrrrr.......

DIDn`t work !!!!!!!!!!!!!!!1

it`s change just one wich is have sub_cat_id #1 ?!?!?

[lynlimz]

huh? whats the change?

[Richi]

now its work
i just put this on the top of the form :

$sql="select * from subcat where sub_cat='$sub_cat'";
    $result=mysql_query($sql,$db);
    $myrow=mysql_fetch_array($result);
    $sub_cat_id=$myrow["sub_cat_id"];
    $sub_cat=$myrow["sub_cat"];
    $catagory=$myrow["catagory"]; 

now i have another Q., ill post in another thered, here now it`s to much

[lynlimz]

glad its resolved. =)
gonna start a book on this thread?

[Richi]

THX alot
for start not bad this my first php & mysql code !

but i have another Q. check it plz

http://www.sitepointforums.com/showt...threadid=31028