[SOLVED] Deletes, but does not add

[Lamez]

My script is suppose to detect if there is a row, and if there is it deletes it, then adds the new values

 

well all it does is delete, I cannot get it to add anything.

 

<?php
  $name = $_POST['name'];
  $url = $_POST['url'];
  $content = $_POST['index'];
  $title = $_POST['title'];
  $id = $_POST['id'];
    
   $q = "Select count(*) as row_count from `home` WHERE id = 1";
   $r = mysql_query($q) or die(mysql_error()."<br /><br />".$q);
   if(mysql_num_rows($r) >0)
   {
   $query = "DELETE FROM `home` WHERE id = 1";
   $result = mysql_query($query);
   $q = "INSERT INTO `home` VALUES ('$id', '$title', '$content')";
   }else{
   $q = "INSERT INTO `home` VALUES ('$id', '$title', '$content')";
   }
   
  echo $name." has been editied";
  echo " You view it here: <a href=".$url.">".$name."</a>.";
?>

[laffin]

why delete it, wen u can update it instead?

 

[Lamez]

I have never used an update query, can you show me how?

[revraz]

http://www.freewebmasterhelp.com/tutorials/phpmysql

[laffin]

u basicly have it all there in yer code

<?php
  $name = $_POST['name'];
  $url = $_POST['url'];
  $content = $_POST['index'];
  $title = $_POST['title'];
  $id = $_POST['id'];
    
   $q = "Select count(*) as row_count from `home` WHERE id = 1";
   $r = mysql_query($q) or die(mysql_error()."<br /><br />".$q);
   if(mysql_num_rows($r) >0)
   {
   $query = "UPDATE `home` SET title='$title,content='$content' WHERE id = 1";
   $result = mysql_query($query);
   }else{
   $q = "INSERT INTO `home` VALUES ('$id', '$title', '$content')";
   }
   
  echo $name." has been editied";
  echo " You view it here: <a href=".$url.">".$name."</a>.";
?>
[code]
result will either be TRUE or FALSE, depending on success

[/code]

[Lamez]

alright, but now it does not update.

 

I can insert a row, but now it will not add the new content after I edit it

[Lamez]

from my original code, what is wrong?

[Northern Flame]

<?php
  $name = $_POST['name'];
  $url = $_POST['url'];
  $content = $_POST['index'];
  $title = $_POST['title'];
  $id = $_POST['id'];
    
   $q = "Select * FROM `home` WHERE `id` = $id";
   $r = mysql_query($q) or die(mysql_error()."<br /><br />".$q);
   if(mysql_num_rows($r) > 0)
   {
   mysql_query("UPDATE `home` SET `name`='$name' WHERE `id`='$id'")or die(mysql_error());
   mysql_query("UPDATE `home` SET `url`='$url' WHERE `id`='$id'")or die(mysql_error());
   mysql_query("UPDATE `home` SET `content`='$content' WHERE `id`='$id'")or die(mysql_error());
   mysql_query("UPDATE `home` SET `title`='$title' WHERE `id`='$id'")or die(mysql_error());
   }else{
   $q = "INSERT INTO `home` (name, url, content, title) VALUES ('$name', '$url', '$content', '$title')";
   mysql_query($q)
   }
   
  echo $name." has been editied";
  echo " You view it here: <a href=".$url.">".$name."</a>.";
?>

[Lamez]

Thanks!