Jump to content


Photo

MySQL-related question


  • Please log in to reply
2 replies to this topic

#1 Bisa

Bisa
  • Members
  • PipPipPip
  • Advanced Member
  • 76 posts
  • LocationSweden

Posted 25 May 2006 - 09:03 AM

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

#2 kooper

kooper
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 25 May 2006 - 09:48 AM

[!--quoteo(post=376935:date=May 25 2006, 10:03 AM:name=Bisa)--][div class=\'quotetop\']QUOTE(Bisa @ May 25 2006, 10:03 AM) View Post[/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
if ($2b || !$2b)
{
echo "that is the question";
}

#3 Bisa

Bisa
  • Members
  • PipPipPip
  • Advanced Member
  • 76 posts
  • LocationSweden

Posted 25 May 2006 - 10:01 AM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users