MySQL-related question

[Bisa]

With some help Im now able to add rows into my table but how do I drop rows? the only thing I can find is the "drop_table" and thats not what I want...

all help/suggestions are welcome

[kooper]

[!--quoteo(post=376935:date=May 25 2006, 10:03 AM:name=Bisa)--][div class=\'quotetop\']QUOTE(Bisa @ May 25 2006, 10:03 AM) [snapback]376935[/snapback][/div][div class=\'quotemain\'][!--quotec--]
With some help Im now able to add rows into my table but how do I drop rows? the only thing I can find is the "drop_table" and thats not what I want...

all help/suggestions are welcome
[/quote]

you can do it the hard way with phpmyadmin

or use this query

$sql = "DELETE FROM the_table WHERE id = '$whatever_your deleting";
$result = mysql_query($sql);

obviously replaceing the_table and whatever_your deleting with whatever you tables and variables are

[Bisa]

thnx, you are my savior ^^ my database started to grow pretty big there :P