[SOLVED] A simple question

[npsari]

How can i delete a specific row from a mySQL table

I want to delete Image2 (or make the value of it is nothing, NULL)

 

<?php

$con = mysql_connect("localhost","name","password");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }

 

mysql_select_db("npsari_other", $con);

 

mysql_query("DELETE Image2 FROM ads WHERE ID='$ID'");

 

mysql_close($con);

 

?>

 

Is this code right, because it doesnt work

[trq]

The query looks fine (even if there is a distict lake of error handling). Where are you defining $ID?

[Mutley]

<?php
$con = mysql_connect("localhost","name","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("npsari_other", $con);

mysql_query("DELETE FROM ads WHERE ID='$ID'");

mysql_close($con);

?> 

 

That would delete the row where the id = $id. I'm not sure what the "Image2" part is referring too?

[npsari]

Hey Thorpe...

 

ID and Image2 come from a link (They work fine)

 

hmm, does it have to do with this:

 

mysql_query("UPDATE ads SET Image1= '$Image2' WHERE ID = '$ID'");
mysql_query("DELETE Image2 FROM ads WHERE ID='$ID'");

 

Because I rename Image1 to Image2 just before i delete Image2

[trq]

Sorry, didn't notice that. Mutley was right, your query should be....

 

mysql_query("DELETE FROM ads WHERE ID='$ID'");

 

However, unless you have register_globals enabled (which you should'nt) you'd need to change it to....

 

mysql_query("DELETE FROM ads WHERE ID='{$_GET['ID']}'");

[npsari]

Thanks Mutley and thrope

 

But i dont want to delete the whole row, sorry

 

I just want to delete the colomb Image2

 

Or make it null (empty)

 

is there a way

[Mutley]

If you want to delete the contents of the column "Image2" just update it to blank, such as:

 

mysql_query("UPDATE ads SET Image2= '' WHERE ID = '$ID'");

[npsari]

Hey, good idea

 

It passed my mind, thought i didnt try it much

 

Now it works perfect

 

Thanks much pal