CODE

CREATE TABLE `businesses` (
 `id` int(10) NOT NULL auto_increment,
 `business` varchar(255) NOT NULL default '',
 `description` text NOT NULL,
 `emailaddress` varchar(255) NOT NULL default '',
 `website` varchar(255) NOT NULL default '',
 PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2;

CODE

<?
include("include/common.php");
global $conn
?>
<style type="text/css">
<!--
.style1 {
font-size: 18px;
font-weight: bold;
}
-->
</style>


<div align="center" class="style1">ADD A NEW BUSINESS TO THE LINK PAGE</div>
<form action="<?=$_SERVER['PHP_SELF']?>" method="POST">
<table border=".01" align="center">
<tr>
<td width="146"><B>Business Name:</b></td>
<td width="172"><input type="text" name="business_name" /></td>
</tr>
<tr>
<td><b>Business Description:</b></td>
<td><textarea name="business_desc" rows="15" cols="20"></textarea></td>
</tr>
<tr>
<td><b>E-Mail Address:</b></td>
<td><input type="text" name="business_email" /></td>
</tr>
<tr>
 <td><B>Website:</b></td>
 <td><div align="center">
       <input name="business_website" type="text" />
       <strong><BR>
       NO HTTP:// </strong>just<strong> WWW<BR>
       eg. www.yahoo.com </strong></div></td>
</tr>
<tr>
<td><input type="submit" name="add" value="Add!" /></td>
<td><input type="reset" value="Reset" /></td>
</tr>
</table>
</form>
<?php

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

mysql_query("INSERT INTO businesses SET business='{$_POST['business_name']}',description='{$_POST['business_desc']}',emailaddress='{$_POST['business_email']}',website='{$_POST['business_website']}'") or die(mysql_error());

echo '<tr bgcolor="red"><td><b>Business added.</b></td></tr>';

} else {

echo '';

}

?>
</body>
</html>

CODE

<?
$business = $_GET['business'];
global $conn
?>

<?

$query=mysql_query("SELECT business,description,emailaddress, website FROM businesses ");

while($row=mysql_fetch_row($query)) echo '<table width="495"><tr><TD><div align="center"><strong>'.$row[0].'</strong></div><BR></td></TR><TR><td><div align="center">'.$row[1].'</div></td></TR><TR><td><div align="center"><B>E-mail:  </B><a href="mailto:'.$row[2].'?subject=test">'.$row[2].'</a><BR></div></td></TR><TR><TD><div align="center"><B>Website:  </B><a href="http://'.$row[3].'"target="_blank">'.$row[3].'</div></td></tr></table><HR width="400">';

?>

CODE

UPDATE 'businesses' SET 'business' = 'some business', 'description' = 'some description', 'emailaddress' = 'some email', 'website' = 'some website' WHERE 'id' = 'id of data to edit';

CODE

mysql_query("UPDATE businesses SET business='{$_POST['business_name']}',description='{$_POST['business_desc']}',emailaddress='{$_POST['business_email']}',website='{$_POST['business_website']}' WHERE id='{$_POST['business_id']}'") or die(mysql_error());

CODE

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

mysql_query("DELETE FROM businesses SET business='{$_POST['business_name']}',description='{$_POST['business_desc']}',emailaddress='{$_POST['business_email']}',website='{$_POST['business_website']}'") or die(mysql_error());

CODE

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 'SET business='sphere',description='',emailaddress='',website=''' at line 1

QUOTE (kopythat)

thanks galahad

That worked great

now if i want to be able to delete from this database the code should be

i have the business id="business_name", but when i delete i get an error

am i doing something wrong????

CODE

[/code]mysql_query("DELETE FROM businesses WHERE business='{$_POST['business_name']}'")

QUOTE (kopythat)

thanks galahad

That worked great

now if i want to be able to delete from this database the code should be

i have the business id="business_name", but when i delete i get an error

am i doing something wrong????

ACTUALLY....is there  a way to see a list of the links, click on the link to edit/delete and have the info show up on the same form i use and update form there.
as of now i have to retype everything, and as long as i have the buusiness name correct it will update, but not delete.

Thanks in advance
Kopy