franknu Posted November 27, 2006 Share Posted November 27, 2006 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"> </td> </tr> </table> </td></table> </tr></body>[/code] Link to comment https://forums.phpfreaks.com/topic/28645-showing-values-from-the-database/ Share on other sites More sharing options...
Orio Posted November 27, 2006 Share Posted November 27, 2006 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 https://forums.phpfreaks.com/topic/28645-showing-values-from-the-database/#findComment-131072 Share on other sites More sharing options...
franknu Posted November 27, 2006 Author Share Posted November 27, 2006 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 252that 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 https://forums.phpfreaks.com/topic/28645-showing-values-from-the-database/#findComment-131092 Share on other sites More sharing options...
marcus Posted November 27, 2006 Share Posted November 27, 2006 [code]</tr>[/code]that is line 252 Link to comment https://forums.phpfreaks.com/topic/28645-showing-values-from-the-database/#findComment-131095 Share on other sites More sharing options...
marcus Posted November 27, 2006 Share Posted November 27, 2006 And with textareas, you can't make the value of it text. You want to do[code]<textarea><?=$textarea?></textarea>[/code] Link to comment https://forums.phpfreaks.com/topic/28645-showing-values-from-the-database/#findComment-131096 Share on other sites More sharing options...
franknu Posted November 27, 2006 Author Share Posted November 27, 2006 ok. It is working, but i still cant get any values in the databasei want the i cant show in any area any value from the database Link to comment https://forums.phpfreaks.com/topic/28645-showing-values-from-the-database/#findComment-131102 Share on other sites More sharing options...
kenrbnsn Posted November 27, 2006 Share Posted November 27, 2006 I would get out of the habit of using short tags "<?" and the echo shortcut "<?=" as these will be going away in PHP v6.Ken Link to comment https://forums.phpfreaks.com/topic/28645-showing-values-from-the-database/#findComment-131103 Share on other sites More sharing options...
marcus Posted November 27, 2006 Share Posted November 27, 2006 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 valuesecho "$busname";//will echo the business name of the id specified?>[/code] Link to comment https://forums.phpfreaks.com/topic/28645-showing-values-from-the-database/#findComment-131105 Share on other sites More sharing options...
franknu Posted November 27, 2006 Author Share Posted November 27, 2006 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`='', `Wei 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"> </td> </tr> </table> </td></table> </tr></body>[/code] Link to comment https://forums.phpfreaks.com/topic/28645-showing-values-from-the-database/#findComment-131126 Share on other sites More sharing options...
franknu Posted November 27, 2006 Author Share Posted November 27, 2006 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"> </td> </tr> </table> </td></table> </tr></body>[/code] Link to comment https://forums.phpfreaks.com/topic/28645-showing-values-from-the-database/#findComment-131194 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.