DaniWeb Forum Index > Web Development > PHP

Deleting rows

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Oct 2009

Posts: 45

Reputation: futhonguy is an unknown quantity at this point

Solved Threads: 0

futhonguy

Offline

Light Poster

Deleting rows

Nov 3rd, 2009

Hi
What i want to do is using php code to write to delete the entire row in the db. each row has its own id, field and content. instead of deleting the row with the id, can i do by the field name? how would i do this?

•

Join Date: Aug 2009

Posts: 49

Reputation: EvolutionFallen is an unknown quantity at this point

Solved Threads: 8

EvolutionFallen EvolutionFallen is offline

Offline

Light Poster

Nov 3rd, 2009

You're looking for

 Help with Code Tags 
 mysql Syntax (Toggle Plain Text) 
DELETE FROM table_name WHERE fieldname = 'value';
DELETE FROM table_name WHERE fieldname = 'value';