UPDATE MySQL help!

Anon

Does anyone know how to UPDATE a field in MySQL. I know its something to do with the UPDATE function. What I am trying to do is update a \"News\" posting, so that it can be changed if I notice something isnt right with it. And also, how would I get it so that it would return the field in the MySQL database to be already entered in the form fields? So that it makes editing easier.

Thanx

Anon

update (tablename) set (fieldname) = (value) where (fieldname) = (value)

Anon

I have yet another 2 questions. If I wanted to say have a link that would delete information from a MySQL database, how exactally would I setup that link? And if I had auto_increments on and id field in MySQL, if i deleted one number, would that through everything off?

Anon

Ok -

First off: ALWAYS reference fields by their ID number - you always want an ID field in your databses.

So:

to UPDATE:
$sql = "UPDATE table SET field = value WHERE id='$id'";

You can use as many field/value pairs as you want, just seperate by a comma.

For example:

$sql = "UPDATE table SET name='$name',date='$date' WHERE id='$id'";

The WHERE clause is important - otherwise, all records in the database will be updated.

to delete:
$sql = "DELETE FROM table WHERE id='$id'";

where $id is the id of the record you want to delete. And no it won't throw things off. It'll go along just fine 🙂

Say you havea table with 5 records, ID's 1,2,3,4,5 - and you run a delete on record 3. Next time you enter a record, it won't fill in that 3 - it will just create a new record, ID 6. No problems there.

Hope I helped!

[ [ Chris ] ]

Anon

ok, now that i understand all that, can someone please explain how to create it so that when I click on the link (Delete) it deletes that data. Would I have to forward it to another page before doing so? Or could I make it somehow to where it would be.

http://www.acidsun.com/index.php?delete=2

where delete=2 would delete the second id.

Is that possible? If so, could anyone tell me, or at least tell me where I could find some info on it.

Thanx

Anon

Sure, it's possible. Just in the index.php page, you'll need something like this:

if(@!$delete) {
//do delete code here, using $delete as the delete id.

}

cheald

Sorry: should be

if(@$delete) {
//do delete code here, using $delete as the delete id.

}

Anon

ok so would it look something like this?

<td width=\"498\"><div align=\"right\"><a href=\"$PHP_SELF?delete=$a_row[id]\"\">Delete<a/> | Modify</div></td>";
if(@$a_row[id]) {

}

Thats what I have. Would I put the if statement before of after to actual link?

Also whenever I try to call it to MySQL in the if statement, it does nothing, like I had

$sql = "DELETE FROM acidnews WHERE id='$a_row[id]'";

This stuff right here is new to me (obviously)