Jump to content

Archived

This topic is now archived and is closed to further replies.

Bisa

MySQL-related question

Recommended Posts

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

Share this post


Link to post
Share on other sites
[!--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

Share this post


Link to post
Share on other sites
thnx, you are my savior ^^ my database started to grow pretty big there :P

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.