Editing Information In A Mysql Database And Deleting Rows

[Mystixs 0]

I need help with a couple of things.First, I need to know how to retrieve information from a mysql database and edit it then re add it to the database.I also would like to know how to easily delete a mysql row.And I want this done without going to phpMyAdmin.Thanks for the help!

[jlhaslip 4]

It will require some server-side coding. Php is commonly used.
Here is a link to a previous topic which deals with the delete aspect.

http://forums.xisto.com/topic/43451-how-to-delete-a-row-in-mysql-a-very-simple-help-required/

Hope this helps.

[Mystixs 0]

Well. I did that thread and for some reason I can't understand it...Btw, I know it uses PHP and Mysql.

[shadowx 0]

Hey there, for a basic example of UPDATE check this: http://www.tizag.com/mysqlTutorial/mysqlupdate.php

 

If you click on the "next" link then youll see an example of delete also.

 

i think its worth expanding on this part though:

 

// Get Sandy's record from the "example" table

$result = mysql_query("UPDATE example SET age='22' WHERE age='21'")

or die(mysql_error());

i dont like the WHERE part of this example so let me show how i would explain...

 

we will assume that there is a table of say usernames and passwords called "users" and a user wants to change their password. So of course they login and put the new password and click a button to change their password. the php code to edit the field "password" in the DB and change it to their new password would be like this assuming their username is "bob" and their old password was "bobspass" and their new password is "bobnew":

 

$result = mysql_query("UPDATE users SET password='bobnew' WHERE username='bob'") or die(mysql_error());

simple

 

the syntax for update is:

UPDATE table_name SET field_name='New_value' WHERE field_name='Old_value'

and DELETE is:

DELETE FROM table_name WHERE field_name='a_value'

If you need help with connecting to the database etc just ask and we will be glad to help. I wont post it now but if you need any more help just ask!

[Saint_Michael 3]

I know I have seen several tutorials on pixel2life about adding tables and info, can't think of the links of the top of my head but I have some others, I know posts some links about mysql db's but have to look for it later and let you know.

[Mystixs 0]

Well, I got the delete thing to work. I will add edit at a later time. Thanks for the help.