Editing a Database

From: Date: Sat, 12 Aug 2000 01:03:55 +0000
Subject: Editing a Database
References: 1 2 3 4  Groups: php.general 
Request: Send a blank email to php-general+get-6042@lists.php.net to get a copy of this message
OK, this one is pretty straightforward, since it's basically the same thing over and over in a loop, but my problem is with getting it right the first time, so it'll repeat correctly. As it is now I use phpMyAdmin to make modifications to the site tables in the site database. What I want to do is make a web interface so that I can delete records without having to go in phpMyAdmin. For example, let's say that my database is called database and my table is called table. In the table let's say I have three fields, product, price, and use (not the real names, but this is just for an example). Basically I want to be able to see the following: products price use fork 5.00 blah1 [delete] spoon 6.00 blah2 [delete] knife 7.00 blah3 [delete] So basically I want the entire table listed (simple loop) and the ability to delete any row from the database. I have a pretty good idea of how to do it, but if someone could give me a little help it'd be great. Thanks! -Jeff

« previous php.general (#6042) next »