Mysql Edit editing info in a MYSQL database

I have a simple database with a php form thats inserts the info into the database, and another file that extracts the info to display the info on another page....

Now my question is ......how do i add the EDIT button to edit the database???

here is my database

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;

here is my form to add

<?	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. 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><?phpif(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>

Here is my display links Page

<?$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">';?>

now i have all the info put in to the database and it displays ok, but how do i edit it to change the info, either email, website, description, and/or even delete

Thank you in advance

Kopy

To edit some data in MySQL database, use UPDATE syntax:

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

Using this code, and of course, modifying 'some something' parts, you can change the data of any record with certain id.

Something that might work instantly for you:

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());

Hope this helped

thanks galahad

That worked great

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

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());

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

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

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

thanks galahad

 

That worked great

 

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

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());

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

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

am i doing something wrong????

64736[/snapback]

If you want to delete something from your database, use the following MySQL query:

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

thanks galahad

 

That worked great

 

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

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());

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

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

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

64736[/snapback]

Beware, it's highly recomended that you clean your vars with some function, just like stripslashes, to prevent SQL Injection.