Jump to content


Photo

Old News


  • Please log in to reply
No replies to this topic

#1 JackJack

JackJack
  • Members
  • PipPipPip
  • Advanced Member
  • 38 posts

Posted 23 April 2006 - 11:44 AM

I have a php which you can update the name of your company.
It works fine except one problem, It shows the old name is the text box and at the bottom it says
"Your in the company 'old name'." Until you refresh it. If i have a refresh it i wont be able to see
You have successfully updayed your company name.
Please Help

<? include ("header.php"); ?>
<?
$name = $_POST['name'];
$tim = time();
?>
<?php
    $companys = mysql_fetch_array(mysql_query("SELECT * FROM `companys` WHERE `name`='$stat[company_name]'"));
?>
<?
if($stat[company_status] == 0){
?>
Your not in a company at the moment.<br>
Click <a href="district" target="_self">here</a> to join or create a company. 
<? }else{ ?>
<?
if($companys[owner] == $stat[display_name]){
?>
<center>
  <h2><u>Change Your Companys Settings</u></h2>
</center><br>

<form name="updatename" method="post" action="company.php?update=name">
<table width="29%" border="2" cellspacing="1" cellpadding="1">
  <tr>
    <th width="53%" bgcolor="#CCCCCC" scope="row">Company Name : </th>
    <td width="47%">
      <div align="center">
        <input name="name" type="text" value="<? echo $companys['name']; ?>" size="20" maxlength="15">
        </div></td>
  </tr>
</table>
<table width="30%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <th height="12" scope="row"><input type="submit" name="Submit2" value="Update"></th>
  </tr>
</table>
</form><br>
<?
if($update == 'name'){
?>
<?php
    $dupe0 = mysql_num_rows(mysql_query("select * from companys where name='$name'"));

    if ($dupe0 > 0) {
?>
There is already a company with that name.
<? }else{ ?>
<?
mysql_query("UPDATE `company_news` SET `company`='$name' WHERE `owner`='$stat[display_name]'");
mysql_query("UPDATE `companys` SET `name`='$name' WHERE `owner`='$stat[display_name]'");
mysql_query("UPDATE `company_news` SET `company`='$name' WHERE `company`='$company[name]'");
mysql_query("UPDATE `players` SET `company_name`='$name' WHERE `id`='$stat[id]'"); 
mysql_query("INSERT INTO `company_news` (sender, title, message, company, owner) VALUES ('Updater','Company Name Updated','Your companys name has been updated to $name.','$name','$stat[display_name]')") or die(mysql_error());
echo "You successfully changed your companys name to <b>$name</b>.";
} } ?>

  <? }else{ ?>

<center>
  <h2><u>View Your Companys Settings</u></h2>
</center>
Your a member.
<? } ?>
<br>
Your in the company <b><? echo $stat[company_name]; ?></b>.
<? } ?>


Thank you

Ps. I know my codings terebaly untidy. Ill sort it out myself when im finished though.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users