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"> </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"> </td>
</tr>
<tr>
<td bgcolor="#2E69A5"> </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%"> </td>
<td width="40%" align="left" valign="top"></td>
<td width="38%" align="left" valign="top"></td>
</tr>
</table></td>
<td bgcolor="#2E69A5"> </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"> </td>
<td height="25" colspan="3" align="left" valign="middle" bgcolor="#5091C5" class="whiteheading"> <span class="txtNavBlue mar10 left">Profile
Edit
- Interests & Personality</span> : </td>
<td width="16" bgcolor="#A3C5E0"> </td>
</tr>
<tr>
<td height="0" bgcolor="#A3C5E0"> </td>
<td height="60" colspan="3" align="center" valign="middle" bgcolor="#A3C5E0"><a href="editprofile.php" class="profilebluebuttons">Interests & Personality</a> <span class="profilebluebuttons">|</span> <a href="editprofile_name.php" class="profilebluebuttons">Name</a> <span class="profilebluebuttons">|</span> <a href="editprofile_basicinfo.php" class="profilebluebuttons">Basic
Info</a> <span class="profilebluebuttons">|</span> <a href="editprofile_background.php" class="profilebluebuttons">Background & Lifestyle</a> <span class="profilebluebuttons">|</span> <a href="editprofile_school.php" class="profilebluebuttons">Schools</a> <span class="profilebluebuttons">|</span> <a href="editprofile_company.php" class="profilebluebuttons">Companies</a> <span class="profilebluebuttons">|</span> <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"> </td>
</tr>
<tr>
<td height="0" bgcolor="#A3C5E0"> </td>
<td height="60" colspan="3" align="center" valign="middle" bgcolor="#A3C5E0"> </td>
<td width="16" bgcolor="#A3C5E0"> </td>
</tr>
<tr>
<td height="0" bgcolor="#A3C5E0"> </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"> </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"> </td>
</tr>
<!-- <tr>
<td height="0" bgcolor="#A3C5E0"> </td>
<td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext"> </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"> </td>
</tr>-->
<tr>
<td height="0" bgcolor="#A3C5E0"> </td>
<td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td width="16" bgcolor="#A3C5E0"> </td>
</tr>
<tr>
<td height="0" bgcolor="#A3C5E0"> </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"> </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"> </td>
</tr>
<!-- <tr>
<td height="0" bgcolor="#A3C5E0"> </td>
<td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext"> </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"> </td>
</tr> -->
<tr>
<td height="0" bgcolor="#A3C5E0"> </td>
<td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td bgcolor="#A3C5E0"> </td>
</tr>
<tr>
<td height="0" bgcolor="#A3C5E0"> </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"> </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"> </td>
</tr>
<!-- <tr>
<td height="0" bgcolor="#A3C5E0"> </td>
<td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext"> </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"> </td>
</tr> -->
<tr>
<td height="0" bgcolor="#A3C5E0"> </td>
<td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td bgcolor="#A3C5E0"> </td>
</tr>
<tr>
<td height="0" bgcolor="#A3C5E0"> </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"> </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"> </td>
</tr>
<!-- <tr>
<td height="0" bgcolor="#A3C5E0"> </td>
<td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext"> </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"> </td>
</tr> -->
<tr>
<td height="0" bgcolor="#A3C5E0"> </td>
<td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td bgcolor="#A3C5E0"> </td>
</tr>
<tr>
<td height="0" bgcolor="#A3C5E0"> </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"> </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"> </td>
</tr>
<!-- <tr>
<td height="0" bgcolor="#A3C5E0"> </td>
<td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext"> </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"> </td>
</tr> -->
<tr>
<td height="0" bgcolor="#A3C5E0"> </td>
<td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td bgcolor="#A3C5E0"> </td>
</tr>
<tr>
<td height="0" bgcolor="#A3C5E0"> </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"> </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"> </td>
</tr>
<!-- <tr>
<td height="0" bgcolor="#A3C5E0"> </td>
<td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext"> </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"> </td>
</tr> -->
<tr>
<td height="0" bgcolor="#A3C5E0"> </td>
<td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td bgcolor="#A3C5E0"> </td>
</tr>
<tr>
<td height="0" bgcolor="#A3C5E0"> </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"> </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"> </td>
</tr>
<!-- <tr>
<td height="0" bgcolor="#A3C5E0"> </td>
<td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext"> </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"> </td>
</tr> -->
<tr>
<td height="0" bgcolor="#A3C5E0"> </td>
<td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td bgcolor="#A3C5E0"> </td>
</tr>
<tr>
<td height="0" bgcolor="#A3C5E0"> </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"> </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"> </td>
</tr>
<!-- <tr>
<td height="0" bgcolor="#A3C5E0"> </td>
<td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext"> </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"> </td>
</tr> -->
<tr>
<td height="0" bgcolor="#A3C5E0"> </td>
<td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td bgcolor="#A3C5E0"> </td>
</tr>
<tr>
<td height="0" bgcolor="#A3C5E0"> </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"> </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"> </td>
</tr>
<!-- <tr>
<td height="0" bgcolor="#A3C5E0"> </td>
<td height="25" align="right" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td align="left" valign="top" bgcolor="#A3C5E0" class="blacktext"> </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"> </td>
</tr> -->
<tr>
<td height="45" align="center" bgcolor="#A3C5E0"> </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"> </td>
</tr>
<tr>
<td height="47" align="center" bgcolor="#A3C5E0"> </td>
<td height="47" colspan="3" align="center" valign="middle" bgcolor="#A3C5E0" class="blacktext"> </td>
<td height="47" align="center" bgcolor="#A3C5E0"> </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">©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`)
)
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]