Jump to content

showing values from the database

franknu

By franknu
in PHP Coding Help

 Share

Recommended Posts

franknu Regular Member

franknu

Posted
Posted
i want to show the values from my database so when the user update the info it doesnt get replace i done many diffrent things but nothing seems to work please help

[code=php:0]

<?php
$host    = "localhost";
$username = "localhost";
$password = "abc123";
$database = "contacts";


$db = mysql_connect($host, $username, $password) or die(mysql_error());
mysql_select_db($database) or die(mysql_error());

$BusinessName = (isset($_POST['BusinessName']) ? $_POST['BusinessName'] : '');
$Slogan = (isset($_POST['Slogan']) ? $_POST['Slogan']:'');
$Business_Address = (isset($_POST['Business_Address']) ? $_POST['Business_Address']:'');
$Tel = (isset($_POST['Tel']) ? $_POST['Tel']:'');
$Website = (isset($_POST['Website']) ? $_POST['Website']:'');
$Email = (isset($_POST['Email']) ? $_POST['Email']:'');
$Member_Status = (isset($_POST['Member_Status']) ? $_POST['Member_Status']:'');
$Fax =(isset($_POST['Fax']) ? $_POST['Fax']:'');
$type = (isset($_POST['type']) ? $_POST['type']:'');
$make = (isset($_POST['make']) ? $_POST['make']:'');
$Categories = (isset($_POST['Categories']) ? $_POST['Categories']:'');
$Keyword = (isset($_POST['Keyword']) ? $_POST['Keyword']:'');
$Picture1 =  (isset($_POST['Picture1']) ? $_POST['Picture1']:'');
$Headline =  (isset($_POST['Headline']) ? $_POST['Headline']:'');
$Slogan2 = (isset($_POST['Slogan2']) ? $_POST['Slogan2']:'');
$Description1 = (isset($_POST['Description1']) ? $_POST['Description1']:'');
$Description2 = (isset($_POST['Description2']) ? $_POST['Description2']:'');
$Description3= (isset($_POST['Description3']) ? $_POST['Description3']:'');
$Contact2 = (isset($_POST['Contact2']) ? $_POST['Contact2']:'');
$Picture2 =  (isset($_POST['Picture2']) ? $_POST['Picture2']:'');
$Picture3 = (isset($_POST['Picture3']) ? $_POST['Picture3']:'');
$Picture4 =  (isset($_POST['Picture4']) ? $_POST['Picture4']:'');
$User_Name = (isset($_POST['User_Name']) ? $_POST['User_Name']:'');
$Password = (isset($_POST['Password']) ? $_POST['Password']: '');
$update= (isset($_GET['update']) ? $_GET['update']:'');

if(isset($_GET['update'])) {//updating}



$query="UPDATE  business_info  SET `BusinessName`= '{$BusinessName}', `Slogan`='{$Slogan}',
              `Business_Address`='{$Business_Address}', `Tel`='{$Tel}', `Website`='{$Website}',
              `Email`='{$Email}', `Member_Status`='{$Member_Status}', `Fax`='{$Fax}', `type`='{$type}',
              `make`='{$make}', `Categories`='{$Categories}', `Keyword`='{$Keyword}', `Picture1`='{$Picture1}',
              `Headline`='{$Headline}', `Slogan2`='{$Slogan2}', `Description1`='{$Description1}',
              `Description2`='{$Description2}', `Description3`= '{$Description3}', `Contact2`='{$Contact2}',
              `Picture2`='{$Picture2}', `Picture3`='{$Picture3}',
              `Password`='{$Password}' WHERE `User_Name`='{$User_Name}'";


$result = mysql_query($query) or die (mysql_error());


  ?>
 
 
<table width="83%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td bordercolor="#FFFFFF" bgcolor="#FFFFFF"><div align="left"><br>
        <table width="96%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
          <tr>
           
            <td width="91%">
<?

include("../includefiles/logo.php");
?>
</td>
          </tr>
        </table>
      </div></td>
  </tr>
  <tr>
    <td><div align="center"></div></td>
  </tr>
  <tr>
    <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
       
  <td width="94%">

<table width="100%" border="0" cellpadding="0" cellspacing="0" background="../images/top_center_back2.jpg" bgcolor="#FFFFFF">
<tr>
  <td>
<table width="100%" height="125" border="0" cellpadding="1" cellspacing="1">
<form  name="form"  method="Post" action="" >
  <tr>
    <td background="../images/fondo2.jpg" bgcolor="#999966"><div align="center"><strong>Business Info</strong></div></td>
  </tr>
  <tr>
    <td><table width="100%" border="0" cellspacing="1" cellpadding="1">
        <tr>
          <td width="17%">Business Name</td>
          <td width="22%"><input type="text" name="BusinessName" value="<? echo "{$BusinessName}" ?>"> </td>
       
        </tr>
        <tr>
          <td>Slogan</td>
          <td><input type="text" name="Slogan" value="<?php echo $Slogan ?>"></td>
          <td>Website</td>
          <td><input type="text" name="Website " value="<?php echo $Website ?>"></td>
        </tr>
        <tr>
          <td>Tel</td>
          <td><input type="text" name="Tel" value="<?php echo $Tel?>"></td>
          <td>Key Words</td>
          <td><input type="text" name="Keyword  value="<?php echo $Keyword ?>"> </td>
        </tr>
        <tr>
          <td>Fax</td>
          <td><input type="text" name="Fax" value="<?php echo $Fax ?>"> </td>
          <td>Address</td>
          <td><input type="text" name="Business_Address" value="<?php echo $Business_Address ?> "> </td>
        </tr>
      </table></td>
  </tr>
  <tr>
    <td>

<table width="101%" height="35" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td width="13%">State</td>
          <td width="7%"> <select name="make" style="width:160px;"></td>
         
          <td width="16%">City</td>
          <td width="8%"><select name="type" style="width:160px;">
                  </select>
 
  </td>
          <td width="9%">Category</td>
          <td width="16%"> <TEXTAREA rows=3  name="Categories" value="<?php echo $Categories?>"> </TEXTAREA> </td>
       
        </tr>
      </table><br>
  <table width="100%" border="0" cellspacing="1" cellpadding="1">
        <tr>
          <td background="../images/fondo2.jpg" bgcolor="#CCCCCC"><div align="center"><strong><font color="#000000">Business
                          Webpage</font></strong></div></td>
        </tr>
        <tr>
          <td>Headline</td>
        </tr>
        <tr>
          <td><input type="text" name="Headline" value="<?php echo $Headline?>"> </td>
        </tr>
        <tr>
          <td>Slogan </td>
        </tr>
        <tr>
          <td><input type="text" name="Slogan2" value="<?php echo $Slogan2?>" ></td>
        </tr>
        <tr>
                      <td>Description1 </td>
        </tr>
        <tr>
          <td><TEXTAREA ROWS=5 COLS=65 NAME="Description1" value="<?php echo $Description1 ?>" > </TEXTAREA></td>
        </tr>
        <tr>
          <td>Description2</td>
        </tr>
        <tr>
          <td><TEXTAREA ROWS=5 COLS=65 NAME="Description2" value="<?php echo $Description2 ?>"></TEXTAREA></td>
        </tr>
        <tr>
          <td>Description3</td>
        </tr>
        <tr>
          <td><TEXTAREA ROWS=5 COLS=65 NAME="Description3" value="<?php echo $Description3 ?> "></TEXTAREA></td>
        </tr>
        <tr>
          <td>Contact Name
            <TEXTAREA ROWS=1 COLS=25 NAME="Contact2" value="<?php echo $Contact2 ?>"> </TEXTAREA></td>
        </tr>
        <tr>
          <td>


          Picture1
  <input name="Picture1" type="file" value="<?php echo $Picture1?>">

   
  </td>
        </tr>
        <tr>
          <td>Picture 2
  <input name="Picture2" type="file" value="<?php echo $Picture2 ?>">
  </td>
        </tr>
        <tr>
          <td>Picture 3 <input name="Picture3" type="file" value="<?php echo $Picture3?>"></td>
        </tr>
<tr>
          <td>
  Audio
  <input name="Audio" type="file" value="<?php echo $Audio?>"> </td>
        </tr>
<tr>
          <td>
  Video
  <input name="video" type="file" value="<?php echo $video?>"></td>
        </tr>
        <tr>
          <td><table width="100%" border="1" cellspacing="1" cellpadding="1">
              <tr>
                <td>User Name</td>
                <td><input type="text" name="User_Name"value="<?php echo $User_Name?>"></td>
                <td>Password</td>
                <td><input type="text" name="Password" value="<?php echo $Password?>"></td>
              </tr>
            </table></td>
        </tr>
      </table> </td>
  </tr>
  <tr>
    <td background="../images/fondo2.jpg"> <div align="right">
        <input type="submit"  value="Update my database" />
        <input type="reset" value="Reset fields" />
      </div><td>
  </form>

</table>

</td>
          <td width="6%" valign="top" bgcolor="#FFFFFF">&nbsp;</td>
        </tr>
      </table>
  </td>
</table>
  </tr>





</body>
[/code]
Link to comment
Share on other sites
Orio Member

Orio

Posted
Posted
Change this:
[code]<input type="submit"  value="Update my database" />[/code]
Into:
[code]<input type="submit"  value="Update my database" name="update" />[/code]

And in these two lines:
[code]$update= (isset($_GET['update']) ? $_GET['update']:'');
if(isset($_GET['update'])) {//updating[/code]
Replace the "$_GET" with "$_POST".

Orio.
Link to comment
Share on other sites
franknu Regular Member

franknu

Posted
  • Author
Posted
ok, now it is givin me  a parser error in my last line :

Parse error: parse error in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 252

that only says <html>

i went and put back exactly as it was and i was still getting the same errror message..

help
Link to comment
Share on other sites
marcus Regular Member

marcus

Posted
Posted
You aren't selecting anything from the database, you're only updating it.

[code]
<?php
//connection stuff here

$query = "SELECT * FROM business_info WHERE id =idnumhere";
$result = mysql_query($query);
$res2 = mysql_fetch_assoc($result);

$busname = $res2[BusinessName];
//other values

echo "$busname";
//will echo the business name of the id specified
?>
[/code]
Link to comment
Share on other sites
franknu Regular Member

franknu

Posted
  • Author
Posted
i made changes to the code here they are now.


the error that i am getting is:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' Slogan='', `Business_Address`='', `Tel`='', `We
i cant see the error please help

[code=php:0]

<?php
$host    = "localhost";
$username = "localhost";
$password = "abc123";
$database = "contacts";


$db = mysql_connect($host, $username, $password) or die(mysql_error());
mysql_select_db($database) or die(mysql_error());

$BusinessName = (isset($_POST['BusinessName']) ? $_POST['BusinessName'] : '');
$Slogan = (isset($_POST['Slogan']) ? $_POST['Slogan']:'');
$Business_Address = (isset($_POST['Business_Address']) ? $_POST['Business_Address']:'');
$Tel = (isset($_POST['Tel']) ? $_POST['Tel']:'');
$Website = (isset($_POST['Website']) ? $_POST['Website']:'');
$Email = (isset($_POST['Email']) ? $_POST['Email']:'');
$Member_Status = (isset($_POST['Member_Status']) ? $_POST['Member_Status']:'');
$Fax =(isset($_POST['Fax']) ? $_POST['Fax']:'');
$type = (isset($_POST['type']) ? $_POST['type']:'');
$make = (isset($_POST['make']) ? $_POST['make']:'');
$Categories = (isset($_POST['Categories']) ? $_POST['Categories']:'');
$Keyword = (isset($_POST['Keyword']) ? $_POST['Keyword']:'');
$Picture1 =  (isset($_POST['Picture1']) ? $_POST['Picture1']:'');
$Headline =  (isset($_POST['Headline']) ? $_POST['Headline']:'');
$Slogan2 = (isset($_POST['Slogan2']) ? $_POST['Slogan2']:'');
$Description1 = (isset($_POST['Description1']) ? $_POST['Description1']:'');
$Description2 = (isset($_POST['Description2']) ? $_POST['Description2']:'');
$Description3= (isset($_POST['Description3']) ? $_POST['Description3']:'');
$Contact2 = (isset($_POST['Contact2']) ? $_POST['Contact2']:'');
$Picture2 =  (isset($_POST['Picture2']) ? $_POST['Picture2']:'');
$Picture3 = (isset($_POST['Picture3']) ? $_POST['Picture3']:'');
$Picture4 =  (isset($_POST['Picture4']) ? $_POST['Picture4']:'');
$User_Name = (isset($_POST['User_Name']) ? $_POST['User_Name']:'');
$Password = (isset($_POST['Password']) ? $_POST['Password']: '');
$update= (isset($_POST['update']) ? $_POST['update']:'');

$query = "SELECT * FROM business_info WHERE `BusinessName`= '$BusinessName', `Slogan='$Slogan'`,
              `Business_Address`='$Business_Address', `Tel`='$Tel', `Website`='$Website',
              `Email`='$Email', `Member_Status`='$Member_Status', `Fax`='$Fax', `type`='$type',
              `make`='$make', `Categories`='$Categories', `Keyword`='$Keyword', `Picture1`='$Picture1',
              `Headline`='$Headline', `Slogan2`='{$Slogan2}', `Description1`='$Description1',
              `Description2`='$Description2', `Description3`= '$Description3', `Contact2`='$Contact2',
              `Picture2`='$Picture2', `Picture3`='$Picture3',
              `Password`='$Password', `User_Name`='$User_Name'";

$result = mysql_query($query) or die (mysql_error());











if(isset($_POST['update']))
{



$query="UPDATE  business_info  SET `BusinessName`= '{$BusinessName}', `Slogan`='{$Slogan}',
              `Business_Address`='{$Business_Address}', `Tel`='{$Tel}', `Website`='{$Website}',
              `Email`='{$Email}', `Member_Status`='{$Member_Status}', `Fax`='{$Fax}', `type`='{$type}',
              `make`='{$make}', `Categories`='{$Categories}', `Keyword`='{$Keyword}', `Picture1`='{$Picture1}',
              `Headline`='{$Headline}', `Slogan2`='{$Slogan2}', `Description1`='{$Description1}',
              `Description2`='{$Description2}', `Description3`= '{$Description3}', `Contact2`='{$Contact2}',
              `Picture2`='{$Picture2}', `Picture3`='{$Picture3}',
              `Password`='{$Password}' WHERE `User_Name`='{$User_Name}'";


$result = mysql_query($query) or die (mysql_error());
}

  ?>
 
 
<table width="83%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td bordercolor="#FFFFFF" bgcolor="#FFFFFF"><div align="left"><br>
        <table width="96%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
          <tr>
           
            <td width="91%">
<?

include("../includefiles/logo.php");
?>
</td>
          </tr>
        </table>
      </div></td>
  </tr>
  <tr>
    <td><div align="center"></div></td>
  </tr>
  <tr>
    <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
       
  <td width="94%">

<table width="100%" border="0" cellpadding="0" cellspacing="0" background="../images/top_center_back2.jpg" bgcolor="#FFFFFF">
<tr>
  <td>
<table width="100%" height="125" border="0" cellpadding="1" cellspacing="1">
<form  name="form"  method="Post" action="" >
  <tr>
    <td background="../images/fondo2.jpg" bgcolor="#999966"><div align="center"><strong>Business Info</strong></div></td>
  </tr>
  <tr>
    <td><table width="100%" border="0" cellspacing="1" cellpadding="1">
        <tr>
          <td width="17%">Business Name</td>
          <td width="22%"><input type="text" name="BusinessName" value="<?  echo"$BusinessName"; ?>"> </td>
       
        </tr>
        <tr>
          <td>Slogan</td>
          <td><input type="text" name="Slogan" value="<?php echo $Slogan ?>"></td>
          <td>Website</td>
          <td><input type="text" name="Website " value="<?php echo $Website ?>"></td>
        </tr>
        <tr>
          <td>Tel</td>
          <td><input type="text" name="Tel" value="<?php echo $Tel?>"></td>
          <td>Key Words</td>
          <td><input type="text" name="Keyword  value="<?php echo $Keyword ?>"> </td>
        </tr>
        <tr>
          <td>Fax</td>
          <td><input type="text" name="Fax" value="<?php echo $Fax ?>"> </td>
          <td>Address</td>
          <td><input type="text" name="Business_Address" value="<?php echo $Business_Address ?> "> </td>
        </tr>
      </table></td>
  </tr>
  <tr>
    <td>

<table width="101%" height="35" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td width="13%">State</td>
          <td width="7%"> <select name="make" style="width:160px;"></td>
         
          <td width="16%">City</td>
          <td width="8%"><select name="type" style="width:160px;">
                  </select>
 
  </td>
          <td width="9%">Category</td>
          <td width="16%"> <TEXTAREA rows=3  name="Categories" value="<?php echo $Categories?>"> </TEXTAREA> </td>
       
        </tr>
      </table><br>
  <table width="100%" border="0" cellspacing="1" cellpadding="1">
        <tr>
          <td background="../images/fondo2.jpg" bgcolor="#CCCCCC"><div align="center"><strong><font color="#000000">Business
                          Webpage</font></strong></div></td>
        </tr>
        <tr>
          <td>Headline</td>
        </tr>
        <tr>
          <td><input type="text" name="Headline" value="<?php echo $Headline?>"> </td>
        </tr>
        <tr>
          <td>Slogan </td>
        </tr>
        <tr>
          <td><input type="text" name="Slogan2" value="<?php echo $Slogan2?>" ></td>
        </tr>
        <tr>
                      <td>Description1 </td>
        </tr>
        <tr>
          <td><TEXTAREA ROWS=5 COLS=65 NAME="Description1" value="<?php echo $Description1 ?>" > </TEXTAREA></td>
        </tr>
        <tr>
          <td>Description2</td>
        </tr>
        <tr>
          <td><TEXTAREA ROWS=5 COLS=65 NAME="Description2" value="<?php echo $Description2 ?>"></TEXTAREA></td>
        </tr>
        <tr>
          <td>Description3</td>
        </tr>
        <tr>
          <td><TEXTAREA ROWS=5 COLS=65 NAME="Description3" value="<?php echo $Description3 ?> "></TEXTAREA></td>
        </tr>
        <tr>
          <td>Contact Name
            <TEXTAREA ROWS=1 COLS=25 NAME="Contact2" value="<?php echo $Contact2 ?>"> </TEXTAREA></td>
        </tr>
        <tr>
          <td>


          Picture1
  <input name="Picture1" type="file" value="<?php echo $Picture1?>">

   
  </td>
        </tr>
        <tr>
          <td>Picture 2
  <input name="Picture2" type="file" value="<?php echo $Picture2 ?>">
  </td>
        </tr>
        <tr>
          <td>Picture 3 <input name="Picture3" type="file" value="<?php echo $Picture3?>"></td>
        </tr>
<tr>
          <td>
  Audio
  <input name="Audio" type="file" value="<?php echo $Audio?>"> </td>
        </tr>
<tr>
          <td>
  Video
  <input name="video" type="file" value="<?php echo $video?>"></td>
        </tr>
        <tr>
          <td><table width="100%" border="1" cellspacing="1" cellpadding="1">
              <tr>
                <td>User Name</td>
                <td><input type="text" name="User_Name"value="<?php echo $User_Name?>"></td>
                <td>Password</td>
                <td><input type="text" name="Password" value="<?php echo $Password?>"></td>
              </tr>
            </table></td>
        </tr>
      </table> </td>
  </tr>
  <tr>
    <td background="../images/fondo2.jpg"> <div align="right">
    <input type="submit"  value="Update my database" name="update" />
        <input type="reset" value="Reset fields" />
      </div><td>
  </form>

</table>

</td>
          <td width="6%" valign="top" bgcolor="#FFFFFF">&nbsp;</td>
        </tr>
      </table>
  </td>
</table>
  </tr>

</body>
[/code]
Link to comment
Share on other sites
franknu Regular Member

franknu

Posted
  • Author
Posted
ok i did the select and still i am not getting the data to display in the form please help here is my new code:

[code=php:0]

<?php
$host    = "localhost";
$username = "localhost";
$password = "abc123";
$database = "contacts";


$db = mysql_connect($host, $username, $password) or die(mysql_error());
mysql_select_db($database) or die(mysql_error());

$BusinessName = (isset($_POST['BusinessName']) ? $_POST['BusinessName'] : '');
$Slogan = (isset($_POST['Slogan']) ? $_POST['Slogan']:'');
$Business_Address = (isset($_POST['Business_Address']) ? $_POST['Business_Address']:'');
$Tel = (isset($_POST['Tel']) ? $_POST['Tel']:'');
$Website = (isset($_POST['Website']) ? $_POST['Website']:'');
$Email = (isset($_POST['Email']) ? $_POST['Email']:'');
$Member_Status = (isset($_POST['Member_Status']) ? $_POST['Member_Status']:'');
$Fax =(isset($_POST['Fax']) ? $_POST['Fax']:'');
$type = (isset($_POST['type']) ? $_POST['type']:'');
$make = (isset($_POST['make']) ? $_POST['make']:'');
$Categories = (isset($_POST['Categories']) ? $_POST['Categories']:'');
$Keyword = (isset($_POST['Keyword']) ? $_POST['Keyword']:'');
$Picture1 =  (isset($_POST['Picture1']) ? $_POST['Picture1']:'');
$Headline =  (isset($_POST['Headline']) ? $_POST['Headline']:'');
$Slogan2 = (isset($_POST['Slogan2']) ? $_POST['Slogan2']:'');
$Description1 = (isset($_POST['Description1']) ? $_POST['Description1']:'');
$Description2 = (isset($_POST['Description2']) ? $_POST['Description2']:'');
$Description3= (isset($_POST['Description3']) ? $_POST['Description3']:'');
$Contact2 = (isset($_POST['Contact2']) ? $_POST['Contact2']:'');
$Picture2 =  (isset($_POST['Picture2']) ? $_POST['Picture2']:'');
$Picture3 = (isset($_POST['Picture3']) ? $_POST['Picture3']:'');
$Picture4 =  (isset($_POST['Picture4']) ? $_POST['Picture4']:'');
$User_Name = (isset($_POST['User_Name']) ? $_POST['User_Name']:'');
$Password = (isset($_POST['Password']) ? $_POST['Password']: '');


$query = "SELECT * FROM business_info WHERE `BusinessName`= '$BusinessName' AND`Slogan`='$Slogan' AND
              `Business_Address`='$Business_Address' AND`Tel`='$Tel' AND `Website`='$Website' AND
              `Email`='$Email' AND `Member_Status`='$Member_Status'AND `Fax`='$Fax' AND `type`='$type' AND
              `make`='$make' AND `Categories`='$Categories' AND `Keyword`='$Keyword' AND `Picture1`='$Picture1' AND
              `Headline`='$Headline' AND `Slogan2`='{$Slogan2}' AND `Description1`='$Description1' AND
              `Description2`='$Description2' AND `Description3`= '$Description3' AND `Contact2`='$Contact2' AND
              `Picture2`='$Picture2' AND `Picture3`='$Picture3' AND
              `Password`='$Password' AND `User_Name`='$User_Name'";

$result = mysql_query($query) or die (mysql_error());



if(isset($_POST['update']))
{



$query="UPDATE  business_info  SET `BusinessName`= '{$BusinessName}', `Slogan`='{$Slogan}',
              `Business_Address`='{$Business_Address}', `Tel`='{$Tel}', `Website`='{$Website}',
              `Email`='{$Email}', `Member_Status`='{$Member_Status}', `Fax`='{$Fax}', `type`='{$type}',
              `make`='{$make}', `Categories`='{$Categories}', `Keyword`='{$Keyword}', `Picture1`='{$Picture1}',
              `Headline`='{$Headline}', `Slogan2`='{$Slogan2}', `Description1`='{$Description1}',
              `Description2`='{$Description2}', `Description3`= '{$Description3}', `Contact2`='{$Contact2}',
              `Picture2`='{$Picture2}', `Picture3`='{$Picture3}',
              `Password`='{$Password}' WHERE `User_Name`='{$User_Name}'";


$result = mysql_query($query) or die (mysql_error());
}

  ?>
 
 
<table width="83%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td bordercolor="#FFFFFF" bgcolor="#FFFFFF"><div align="left"><br>
        <table width="96%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
          <tr>
           
            <td width="91%">
<?

include("../includefiles/logo.php");
?>
</td>
          </tr>
        </table>
      </div></td>
  </tr>
  <tr>
    <td><div align="center"></div></td>
  </tr>
  <tr>
    <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
       
  <td width="94%">

<table width="100%" border="0" cellpadding="0" cellspacing="0" background="../images/top_center_back2.jpg" bgcolor="#FFFFFF">
<tr>
  <td>
<table width="100%" height="125" border="0" cellpadding="1" cellspacing="1">
<form  name="form"  method="Post" action="" >
  <tr>
    <td background="../images/fondo2.jpg" bgcolor="#999966"><div align="center"><strong>Business Info</strong></div></td>
  </tr>
  <tr>
    <td><table width="100%" border="0" cellspacing="1" cellpadding="1">
        <tr>
          <td width="17%">Business Name</td>
          <td width="22%"><input type="text" name="BusinessName" value="<?  echo"$BusinessName"; ?>"> </td>
       
        </tr>
        <tr>
          <td>Slogan</td>
          <td><input type="text" name="Slogan" value="<?php echo $Slogan ?>"></td>
          <td>Website</td>
          <td><input type="text" name="Website " value="<?php echo $Website ?>"></td>
        </tr>
        <tr>
          <td>Tel</td>
          <td><input type="text" name="Tel" value="<?php echo $Tel?>"></td>
          <td>Key Words</td>
          <td><input type="text" name="Keyword  value="<?php echo $Keyword ?>"> </td>
        </tr>
        <tr>
          <td>Fax</td>
          <td><input type="text" name="Fax" value="<?php echo $Fax ?>"> </td>
          <td>Address</td>
          <td><input type="text" name="Business_Address" value="<?php echo $Business_Address ?> "> </td>
        </tr>
      </table></td>
  </tr>
  <tr>
    <td>

<table width="101%" height="35" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td width="13%">State</td>
          <td width="7%"> <select name="make" style="width:160px;"></td>
         
          <td width="16%">City</td>
          <td width="8%"><select name="type" style="width:160px;">
                  </select>
 
  </td>
          <td width="9%">Category</td>
          <td width="16%"> <TEXTAREA rows=3  name="Categories" value="<?php echo $Categories?>"> </TEXTAREA> </td>
       
        </tr>
      </table><br>
  <table width="100%" border="0" cellspacing="1" cellpadding="1">
        <tr>
          <td background="../images/fondo2.jpg" bgcolor="#CCCCCC"><div align="center"><strong><font color="#000000">Business
                          Webpage</font></strong></div></td>
        </tr>
        <tr>
          <td>Headline</td>
        </tr>
        <tr>
          <td><input type="text" name="Headline" value="<?php echo $Headline?>"> </td>
        </tr>
        <tr>
          <td>Slogan </td>
        </tr>
        <tr>
          <td><input type="text" name="Slogan2" value="<?php echo $Slogan2?>" ></td>
        </tr>
        <tr>
                      <td>Description1 </td>
        </tr>
        <tr>
          <td><TEXTAREA ROWS=5 COLS=65 NAME="Description1" value="<?php echo $Description1 ?>" > </TEXTAREA></td>
        </tr>
        <tr>
          <td>Description2</td>
        </tr>
        <tr>
          <td><TEXTAREA ROWS=5 COLS=65 NAME="Description2" value="<?php echo $Description2 ?>"></TEXTAREA></td>
        </tr>
        <tr>
          <td>Description3</td>
        </tr>
        <tr>
          <td><TEXTAREA ROWS=5 COLS=65 NAME="Description3" value="<?php echo $Description3 ?> "></TEXTAREA></td>
        </tr>
        <tr>
          <td>Contact Name
            <TEXTAREA ROWS=1 COLS=25 NAME="Contact2" value="<?php echo $Contact2 ?>"> </TEXTAREA></td>
        </tr>
        <tr>
          <td>


          Picture1
  <input name="Picture1" type="file" value="<?php echo $Picture1?>">

   
  </td>
        </tr>
        <tr>
          <td>Picture 2
  <input name="Picture2" type="file" value="<?php echo $Picture2 ?>">
  </td>
        </tr>
        <tr>
          <td>Picture 3 <input name="Picture3" type="file" value="<?php echo $Picture3?>"></td>
        </tr>
<tr>
          <td>
  Audio
  <input name="Audio" type="file" value="<?php echo $Audio?>"> </td>
        </tr>
<tr>
          <td>
  Video
  <input name="video" type="file" value="<?php echo $video?>"></td>
        </tr>
        <tr>
          <td><table width="100%" border="1" cellspacing="1" cellpadding="1">
              <tr>
                <td>User Name</td>
                <td><input type="text" name="User_Name"value="<?php echo $User_Name?>"></td>
                <td>Password</td>
                <td><input type="text" name="Password" value="<?php echo $Password?>"></td>
              </tr>
            </table></td>
        </tr>
      </table> </td>
  </tr>
  <tr>
    <td background="../images/fondo2.jpg"> <div align="right">
    <input type="submit"  value="Update my database" name="update" />
        <input type="reset" value="Reset fields" />
      </div><td>
  </form>

</table>

</td>
          <td width="6%" valign="top" bgcolor="#FFFFFF">&nbsp;</td>
        </tr>
      </table>
  </td>
</table>
  </tr>

</body>
[/code]
Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.