Editing Information In A Mysql Database And Deleting Rows

Mystixs

Feb 1 2007, 01:12 AM

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

Feb 1 2007, 01:45 AM

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://www.trap17.com/forums/how-delete-ro...sql-t43451.html

Hope this helps.

Mystixs

Feb 1 2007, 01:48 AM

Well. I did that thread and for some reason I can't understand it...

Btw, I know it uses PHP and Mysql.

shadowx

Feb 1 2007, 03:33 PM

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:

QUOTE

// 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":

CODE

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

simple

the syntax for update is:

CODE

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

and DELETE is:

CODE

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

Feb 2 2007, 02:02 AM

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

Feb 2 2007, 05:09 AM

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

ADD REPLY / Got an Opinion!	a humble request :-)	RAPID SEARCH!	Free Hosting	[X]
Express your Opinions, Thoughts or Contribute your information that might help someone here. Ask your Doubts & Queries to get answers.. "Together, We enlight each other!"	Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.		500MB Space No Ads, CPanel, FTP, PHP, MySQL, EMails - 100% FREE