update problem

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
purnendu231172
Forum Newbie
Posts: 11
Joined: Mon Apr 16, 2007 6:29 am

update problem

Post by purnendu231172 »

Hi all,

i am getting problem in updation. i have requirment. if record is not there in database then insert the record otherwise update the record (if already record is there). It is inserting or updating fine but problem is that, after updation i need to represh (F5) the page to make the changes.

i want , i after preshing submit button, without refresh , i want the value should reflect into the form. I have writen select, insert, update command in one form.

Plz give the solution so that without fresh i fetch my data from database table.

This is my code::::::::::::::::::::::::::::

Code: Select all

<?php
session_start();
include 'connection.php';


$sqry="select * from register_dtl where uname='".$_SESSION['username']."'";
$rs_sel=mysql_query($sqry) or die("error:". mysql_error());
$row_sel=mysql_fetch_assoc($rs_sel);
$no_of_rows_s=mysql_num_rows($rs_sel);
$sel_headline=$row_sel['headline'];
$sel_aboutme=$row_sel['about_me'];
$sel_liketo_meet=$row_sel['liketo_meet'];
$sel_interests=$row_sel['interests'];
$sel_music=$row_sel['music'];
$sel_movies=$row_sel['movies'];
$sel_television=$row_sel['television'];
$sel_books=$row_sel['books'];
$sel_heroes=$row_sel['heroes'];
if($no_of_rows_s ==0)
{
if(isset($_REQUEST['headline']) && $_REQUEST['headline']!="")
{
$headline=$_POST['headline'];
$about_me=$_POST['about_me'];
$liketo_meet=$_POST['liketo_meet'];
$interests=$_POST['interests'];
$music=$_POST['music'];
$movies=$_POST['movies'];
$television=$_POST['television'];
$books=$_POST['books'];
$heroes=$_POST['heroes'];

$qry_ins="insert into register_dtl(uname,headline,about_me,liketo_meet,interests,music,movies,television,books,heroes) values
('".$_SESSION['username']."','$headline','$about_me','$liketo_meet','$interests','$music','$movies','$television', '$books', '$heroes')";
$rs_ins=mysql_query($qry_ins) or die("error:". mysql_error());
}
}
else
{
if(isset($_REQUEST['headline']) && $_REQUEST['headline']!="")
{

$headline1=$_POST['headline'];
$about_me1=$_POST['about_me'];
$liketo_meet1=$_POST['liketo_meet'];
$interests1=$_POST['interests'];
$music1=$_POST['music'];
$movies1=$_POST['movies'];
$television1=$_POST['television'];
$books1=$_POST['books'];
$heroes1=$_POST['heroes'];

	$update="update register_dtl set uname='".$_SESSION['username']."',
											headline='$headline1',
											about_me='$about_me1',
											liketo_meet='$liketo_meet1',
											interests='$interests1',
											music='$music1',
											movies='$movies1',
											television='$television1',
											books='$books1',
											heroes='$heroes1'
											where uname='".$_SESSION['username']."'";  

$rs=mysql_query($update) or die("error:". mysql_error());

}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>aifilia</title>
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}

-->
</style>
<script type="text/javascript" src="base.js"></script>
<script type="text/javascript" src="register.js"></script>
<script type="text/javascript" src="growth.js"></script>
<script type="text/javascript" src="jquery.js"></script>
<script language="JavaScript1.2" type="text/javascript">

// Script Source: CodeLifter.com
// Copyright 2003
// Do not remove this header

isIE=document.all;
isNN=!document.all&&document.getElementById;
isN4=document.layers;
isHot=false;

function ddInit(e){
  topDog=isIE ? "BODY" : "HTML";
  whichDog=isIE ? document.all.theLayer : document.getElementById("theLayer");  
  hotDog=isIE ? event.srcElement : e.target;  
  while (hotDog.id!="titleBar"&&hotDog.tagName!=topDog){
    hotDog=isIE ? hotDog.parentElement : hotDog.parentNode;
  }  
  if (hotDog.id=="titleBar"){
    offsetx=isIE ? event.clientX : e.clientX;
    offsety=isIE ? event.clientY : e.clientY;
    nowX=parseInt(whichDog.style.left);
    nowY=parseInt(whichDog.style.top);
    ddEnabled=true;
    document.onmousemove=dd;
  }
}

function dd(e){
  if (!ddEnabled) return;
  whichDog.style.left=isIE ? nowX+event.clientX-offsetx : nowX+e.clientX-offsetx; 
  whichDog.style.top=isIE ? nowY+event.clientY-offsety : nowY+e.clientY-offsety;
  return false;  
}

function ddN4(whatDog){
  if (!isN4) return;
  N4=eval(whatDog);
  N4.captureEvents(Event.MOUSEDOWN|Event.MOUSEUP);
  N4.onmousedown=function(e){
    N4.captureEvents(Event.MOUSEMOVE);
    N4x=e.x;
    N4y=e.y;
  }
  N4.onmousemove=function(e){
    if (isHot){
      N4.moveBy(e.x-N4x,e.y-N4y);
      return false;
    }
  }
  N4.onmouseup=function(){
    N4.releaseEvents(Event.MOUSEMOVE);
  }
}
function hideMe(){
  if (isIE||isNN) whichDog.style.visibility="hidden";
  else if (isN4) document.theLayer.visibility="hide";
}
function showMe()
{
  if (isIE||isNN) whichDog.style.visibility="visible";
  else if (isN4) document.theLayer.visibility="show";
  getFocus();
}
function getFocus()
{
document.getElementsByTagName ('div')[0].getElementsByTagName ('input')[0].focus();
//alert(document.getElementsByTagName ('div')[0].getElementsByTagName ('input')[0].name);

}
function fun()
{
alert("Please Login");
if (isIE||isNN) whichDog.style.visibility="visible";
  else if (isN4) document.theLayer.visibility="show";
 document.f1.textfield22.focus(); 
}

document.onmousedown=ddInit;
document.onmouseup=Function("ddEnabled=false");


<!-- addded by ranjan----------------------------------->
function update1()
{
	document.frmUpdate.action="product_view.php?update=1&slno="+document.frmUpdate.hddslno.value;
	document.frmUpdate.submit();
}
function save()
{
	document.frmUpdate.action="editprofile.php?save=1&slno="+document.frmUpdate.hddslno.value;;
	document.frmUpdate.submit();
}

function cancel1()
{
	document.frmUpdate.action="product_view.php?slno="+document.frmUpdate.hddslno.value;
	document.frmUpdate.submit();
}


</script>

<link href="css/aifiliacss.css" rel="stylesheet" type="text/css" />
</head>

<body>
<table width="1000" border="0" align="center" cellpadding="0" cellspacing="0">

  <tr>
    <td><table width="1000" border="0" align="center" cellpadding="0" cellspacing="0">
	
      <tr>
        <td width="80" height="30" bgcolor="#2E69A5">&nbsp;</td>
        <td width="6" align="left" valign="top"><img src="images/topstrip.gif" alt="aifilia" width="6" height="30" /></td>
        <td width="210" height="30" bgcolor="#4095EF"></td>
        <td width="117" bgcolor="#4095EF"><a href="javascript: void showMe();" class="login" tabindex="0">Login</a></td>
        <td width="212" bgcolor="#4095EF"><a href="#" class="pinkheadings">JOIN
            NOW</a>
			<!-- BEGIN FLOATING LAYER CODE //-->
                              <div id="theLayer" style="position:absolute; width:250px; left:301px; top:27px; visibility:hidden; "> 
                                
								<table width="250"  border="0" cellpadding="0" cellspacing="0" >
                                  <tr> 
                                    <td width="5" align="right" valign="top"><img src="images/loginbg1left.gif" alt="left" width="5" height="90" />                                     </td>
                                    <td width="240" align="center" valign="top" background="images/loginbg1.gif"><table width="100%" align="center">
                                      <tr>
                                        <td width="69"  align="right" valign="middle" class="logintextblack">Email
                                          Id:</td>
                                        <td height="26" colspan="2" align="left" valign="middle"><input type="text" id="textfield22" name="textfield22" tabindex="1" /></td>
                                      </tr>
                                      <tr>
                                        <td align="right" valign="middle" class="logintextblack">Password:</td>
                                        <td colspan="2" align="left" valign="middle"><input type="password" id="textfield2" name="textfield2" onkeypress="chekEnter(this,event);" tabindex="2" /></td>
                                      </tr>
                                      <tr>
                                        <td align="right" valign="middle"><!--<input type="button" id="btnLogin" name="btnLogin" value="Login">-->
                                        </td>
                                        <td width="65" align="left" valign="middle"><a href="javascript:formsubmit();" class="login"><img src="login_h.gif" border="0" width="65" height="20" alt="" /></a></td>
                                        <td width="90" align="left" valign="middle"><a href="javascript:hideMe();" class="login"><img src="cancel_h.gif" border="0" width="65" height="20" alt="" /></a></td>
                                      </tr>
                                    </table></td>
                                    <td width="2%" align="right" valign="top"><img src="images/loginbg1right.gif" alt="right" width="5" height="90" /></td>
                                  </tr>
                                </table>
            </div>
                              <!-- END FLOATING LAYER CODE //-->
		  </td>
        <td width="60" align="left" valign="middle" bgcolor="#4095EF" class="whitetext">Search</td>
        <td width="169" align="left" valign="middle" bgcolor="#4095EF"><input type="text" name="textfield" /></td>
        <td width="52" align="left" valign="middle" bgcolor="#4095EF"><img src="images/go.gif" alt="go" width="35" height="20" /></td>
        <td width="6" align="right" valign="top"><img src="images/topstripright.gif" alt="aifilia" width="6" height="30" /></td>
        <td width="88" bgcolor="#2E69A5">&nbsp;</td>
      </tr>
      <tr>
        <td bgcolor="#2E69A5">&nbsp;</td>
        <td height="70" colspan="8" align="left" valign="middle" bgcolor="#2E69A5"><table width="100%" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td width="18%" align="center" valign="middle"><img src="images/logo.gif" alt="aifilia" width="98" height="60" /></td>
            <td width="4%">&nbsp;</td>
            <td width="40%" align="left" valign="top"></td>
            <td width="38%" align="left" valign="top"></td>
          </tr>
        </table></td>
        <td bgcolor="#2E69A5">&nbsp;</td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td height="28" align="center" valign="middle" bgcolor="#4791C5">
<?php
if($_SESSION['username']=="")
{
?>
	<a href="index.php" class="topwhitebuttons">Home</a>
<?php
}
else
{
?>
<a href="home.php" class="topwhitebuttons">Home</a>
<?
}
?>
 <span class="topwhitebuttons">|</span> <a href="search.html" class="topwhitebuttons">Search</a>      <span class="topwhitebuttons">|</span> <a href="invite.html" class="topwhitebuttons">Invite</a> <span class="topwhitebuttons">|</span> <a href="blog.html" class="topwhitebuttons">Blog</a> <span class="topwhitebuttons">|</span> <a href="favorites.html" class="topwhitebuttons">Favorites</a> <span class="topwhitebuttons">|</span> <a href="forum.html" class="topwhitebuttons">Forum</a> <span class="topwhitebuttons">|</span> <a href="groups.html" class="topwhitebuttons">Groups</a> <span class="topwhitebuttons">|</span> <a href="events.html" class="topwhitebuttons">Events</a> <span class="topwhitebuttons">|</span> <a href="videos.html" class="topwhitebuttons">Videos</a> <span class="topwhitebuttons">|</span> <a href="music.html" class="topwhitebuttons">Music</a>    <span class="topwhitebuttons">|</span> <a href="stations.html" class="topwhitebuttons">Stations</a> <span class="topwhitebuttons">|</span>
<?php
if($_SESSION['username']=="")
{
?>
	<a href="school.html" class="topwhitebuttons">School</a>
<?php
}
else
{
?>
<a href="editprofile_school.php" class="topwhitebuttons">School</a>
<?
}
?><span class="topwhitebuttons">|</span> <a href="classifieds.html" class="topwhitebuttons">Classifieds</a> </td>
  </tr>
  <tr>
    <td height="5"></td>
  </tr>
  <tr>
    <td align="left" valign="top"><table width="1000" border="0" cellspacing="0" cellpadding="2">
		
      <tr>
        <td width="820" align="left" valign="top"><table width="819" border="0" cellspacing="0" cellpadding="0">
		<form name="frmUpdate" method="post" action="editprofile.php">
		 <input type="hidden" name="hddslno" value="<?php echo $_SESSION['username']; ?>">
          <tr>
            <td width="16"><img src="images/formbglt.gif" alt="top" width="16" height="16" /></td>
            <td width="184" align="left" valign="top" bgcolor="#A3C5E0"></td>
            <td width="7" align="left" valign="top" bgcolor="#A3C5E0"></td>
            <td width="596" align="left" valign="top" bgcolor="#A3C5E0"></td>
            <td width="16" align="left" valign="top"><img src="images/formbgrt.gif" alt="top" width="16" height="16" /></td>
          </tr>
          <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" colspan="3" align="left" valign="middle" bgcolor="#5091C5" class="whiteheading">&nbsp;&nbsp;&nbsp;<span class="txtNavBlue mar10 left">Profile
                Edit&nbsp;
              - Interests & Personality</span> : </td>
            <td width="16" bgcolor="#A3C5E0">&nbsp;</td>
          </tr>
          <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="60" colspan="3" align="center" valign="middle" bgcolor="#A3C5E0"><a href="editprofile.php" class="profilebluebuttons">Interests & Personality</a>&nbsp;<span class="profilebluebuttons">|</span>&nbsp;<a href="editprofile_name.php" class="profilebluebuttons">Name</a>&nbsp;<span class="profilebluebuttons">|</span>&nbsp;<a href="editprofile_basicinfo.php" class="profilebluebuttons">Basic
                Info</a>&nbsp;<span class="profilebluebuttons">|</span>&nbsp;<a href="editprofile_background.php" class="profilebluebuttons">Background & Lifestyle</a>&nbsp;<span class="profilebluebuttons">|</span>&nbsp;<a href="editprofile_school.php" class="profilebluebuttons">Schools</a>&nbsp;<span class="profilebluebuttons">|</span> <a href="editprofile_company.php" class="profilebluebuttons">Companies</a>&nbsp;<span class="profilebluebuttons">|</span>&nbsp;<a href="editprofile_networking.php" class="profilebluebuttons">Networking</a> <span class="profilebluebuttons">|</span> <a href="editprofile_songsvideo.php" class="profilebluebuttons">Song & Video
                on Profile</a></td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr>
          <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
                <td height="60" colspan="3" align="center" valign="middle" bgcolor="#A3C5E0">&nbsp;</td>
            <td width="16" bgcolor="#A3C5E0">&nbsp;</td>
          </tr>
          <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext"><strong>Head
                Line:</strong></td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"><span class="formline">
              <input name="headline" type="text" id="headline" size="60" value="<? echo $row_sel['headline'] ?>"/>
            </span></td>
            <td width="16" bgcolor="#A3C5E0">&nbsp;</td>
          </tr>
      <!--    <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"><input name="btn22" id="btn22" value="Preview Section" type="button" />
                <input name="btn222" id="btn222" value="Preview Profile" type="button" /></td>
            <td width="16" bgcolor="#A3C5E0">&nbsp;</td>
          </tr>-->
          <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td width="16" bgcolor="#A3C5E0">&nbsp;</td>
          </tr> 
          <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="top" bgcolor="#A3C5E0" class="blacktext"><strong>About
                me:</strong> </td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"><textarea name="about_me" cols="45" rows="12" id="about_me"><? echo $sel_aboutme ?></textarea></td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr>
      <!--    <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"><input name="btn22" id="btn22" value="Preview Section" type="button" />
                <input name="btn222" id="btn222" value="Preview Profile" type="button" /></td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr> -->
          <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr>
          <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="top" bgcolor="#A3C5E0" class="blacktext"><strong>I'd
                Like to meet:</strong> </td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"><textarea name="liketo_meet" cols="45" rows="12" id="liketo_meet"><? echo $sel_liketo_meet ?></textarea></td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr>
     <!--     <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"><input name="btn22" id="btn22" value="Preview Section" type="button" />
                <input name="btn222" id="btn222" value="Preview Profile" type="button" /></td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr>  -->
          <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr>
          <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="top" bgcolor="#A3C5E0" class="blacktext"><strong>Intreststs:</strong> </td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"><textarea name="interests" cols="45" rows="5" id="interests"><? echo $sel_interests ?></textarea></td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr>
     <!--     <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"><input name="btn22" id="btn22" value="Preview Section" type="button" />
                <input name="btn222" id="btn222" value="Preview Profile" type="button" /></td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr>   -->
          <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr>
          <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="top" bgcolor="#A3C5E0" class="blacktext"><strong>Music:</strong> </td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"><textarea name="music" cols="45" rows="5" id="nusic"><? echo $sel_music ?></textarea></td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr>
    <!--      <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"><input name="btn22" id="btn22" value="Preview Section" type="button" />
                <input name="btn222" id="btn222" value="Preview Profile" type="button" /></td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr>   -->
          <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr>
          <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="top" bgcolor="#A3C5E0" class="blacktext"><strong>movies:</strong> </td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"><textarea name="movies" cols="45" rows="5" id="movies"><? echo $sel_movies ?></textarea></td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr>
      <!--    <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"><input name="btn22" id="btn22" value="Preview Section" type="button" />
                <input name="btn222" id="btn222" value="Preview Profile" type="button" /></td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr>  -->
          <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr>
          <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="top" bgcolor="#A3C5E0" class="blacktext"><strong>Television:</strong> </td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"><textarea name="television" cols="45" rows="5" id="television"><? echo $sel_television ?></textarea></td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr>
   <!--       <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"><input name="btn22" id="btn22" value="Preview Section" type="button" />
                <input name="btn222" id="btn222" value="Preview Profile" type="button" /></td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr>  -->
          <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr>
          <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="top" bgcolor="#A3C5E0" class="blacktext"><strong>Books:</strong> </td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"><textarea name="books" cols="45" rows="5" id="books"><? echo $sel_books ?></textarea></td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr>
      <!--    <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"><input name="btn22" id="btn22" value="Preview Section" type="button" />
                <input name="btn222" id="btn222" value="Preview Profile" type="button" /></td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr>   -->
          <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr>
          <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="top" bgcolor="#A3C5E0" class="blacktext"><strong>Heroes:</strong> </td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"><textarea name="heroes" cols="45" rows="5" id="heroes"><? echo $sel_heroes ?></textarea></td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr>
     <!--     <tr>
            <td height="0" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"><input name="btn22" id="btn22" value="Preview Section" type="button" />
                <input name="btn222" id="btn222" value="Preview Profile" type="button" /></td>
            <td bgcolor="#A3C5E0">&nbsp;</td>
          </tr>  -->
          <tr>
            <td height="45" align="center" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="45" colspan="3" align="center" valign="middle" bgcolor="#A3C5E0" class="blacktext"><input name="save" id="save" value="Save All " type="submit" onclick="save();">
                <input name="reset" id="reset" value="cancel" type="reset" /></td>
            <td height="45" align="center" bgcolor="#A3C5E0">&nbsp;</td>
          </tr>
          <tr>
            <td height="47" align="center" bgcolor="#A3C5E0">&nbsp;</td>
            <td height="47" colspan="3" align="center" valign="middle" bgcolor="#A3C5E0" class="blacktext">&nbsp;</td>
            <td height="47" align="center" bgcolor="#A3C5E0">&nbsp;</td>
          </tr>
          <tr>
            <td width="16" height="16" align="center" valign="bottom"><img src="images/formbglb.gif" alt="bottom" width="16" height="16" /></td>
            <td height="16" colspan="3" align="center" valign="middle" bgcolor="#A3C5E0" class="blacktext"></td>
            <td height="16" align="center"><img src="images/formbgrb.gif" alt="bottom" width="16" height="16" /></td>
          </tr>
			</form>
        </table></td>
        <td width="5" align="left" valign="top" class="addhline"></td>
        <td width="175" align="left" valign="top"><img src="images/googleadd.gif" width="165" height="376" /></td>
      </tr> 
    </table></td>
  </tr>
  <tr>
    <td height="10"></td>
  </tr>
  <tr>
    <td height="20" align="center" valign="middle" bgcolor="#4891C6"><p><a href="aboutus.html" class="topwhitebuttons">About
    Us</a> <span class="topwhitebuttons">|</span> <a href="terms.html" class="topwhitebuttons">Terms & Conditions</a> <span class="topwhitebuttons">|</span> <a href="privacy.html" class="topwhitebuttons">Privacy
    Policy</a> <span class="topwhitebuttons">|</span> <a href="help.html" class="topwhitebuttons">Help</a> <span class="topwhitebuttons">|</span> <a href="contact.html" class="topwhitebuttons">Contact Us</a></p>    </td>
  </tr>
  <tr>
    <td height="20" align="center" valign="middle" bgcolor="#4891C6" class="whitetext">&copy;2007
    aifilia.com All Rights Reserved.</td>
  </tr>

  </td>
</table>
</body>
</html>

This is my databse table::::::::::

Code: Select all

CREATE TABLE `register_dtl` (
  `sno` int(15) NOT NULL auto_increment,
  `uname` varchar(250) collate latin1_general_ci NOT NULL,
   `headline` varchar(250) collate latin1_general_ci NOT NULL,
  `about_me` text collate latin1_general_ci NOT NULL,
  `liketo_meet` text collate latin1_general_ci NOT NULL,
  `interests` text collate latin1_general_ci NOT NULL,
  `music` text collate latin1_general_ci NOT NULL,
  `movies` text collate latin1_general_ci NOT NULL,
  `television` text collate latin1_general_ci NOT NULL,
  `books` text collate latin1_general_ci NOT NULL,
  `heroes` text collate latin1_general_ci NOT NULL,
    PRIMARY KEY  (`sno`),
  UNIQUE KEY `uname` (`uname`)
)
Please help , it is urgent

Thanks & Regards

Ranjan



hawleyjr | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color][/size]
Grim...
DevNet Resident
Posts: 1445
Joined: Tue May 18, 2004 5:32 am
Location: London, UK

Post by Grim... »

Please use [ php ] tags around your code.

Can you not add

Code: Select all

header ("location: mypage.php");
after the update?
User avatar
CoderGoblin
DevNet Resident
Posts: 1425
Joined: Tue Mar 16, 2004 10:03 am
Location: Aachen, Germany

Post by CoderGoblin »

Properly used:

Code: Select all

header ("location: http://full.url.of.my.page.php"); 
exit;
Without the exit; the rest of the code will still run before jumping. Full url paths when using header location should always be used.
Grim...
DevNet Resident
Posts: 1445
Joined: Tue May 18, 2004 5:32 am
Location: London, UK

Post by Grim... »

CoderGoblin wrote:Full url paths when using header location should always be used.
Ooh, really?
Why's that?
User avatar
CoderGoblin
DevNet Resident
Posts: 1425
Joined: Tue Mar 16, 2004 10:03 am
Location: Aachen, Germany

Post by CoderGoblin »

feyd wrote:header Location, although isn't required for a lot of browsers, some older ones will require a full url in it.
Post Reply