Posted by Anonymous Sat 24th Mar 2007 04:45 - Syntax is None/text - 29 views
Download | New Post | Modify | Hide line numbers
Description:
trying to delete items but it wont work for some reason. i know that it calls
the right things and gets to the if statement but not sure what happens next.
the add feature works fine.

  1.  
  2. if(isset($_POST['add']))
  3. {
  4.   $title = $_POST['title'];
  5.   $content_news = $_POST['content_news'];
  6.   $forward_link = $_POST['forward_link'];
  7.  
  8.   $res = mysql_query("INSERT INTO news (title, content_news, forward_link)
  9.     VALUES ('" . $title . "',  '". $content_news ."',  '". $forward_link ."')");
  10.  
  11.   if ( !$res )
  12.   {
  13.     echo("SQL Error: ". mysql_error());
  14.   }
  15. }
  16.  
  17. if(isset($_POST['delete']))
  18. {
  19. mysql_query("delete from news where email='".$id."'");
  20.  
  21. }
  22.  
  23.  
  24.  
  25.  
  26.  
  27. $query="SELECT * FROM news";
  28. $result=mysql_query($query);
  29. $num=mysql_numrows($result);
  30.  
  31.  
  32. mysql_close($dbh);
  33.  
  34. ?>
  38.            
  40.  
  41. Computer Museum
  44.  

  46. Add News

  48.  
    54. Title
    Passage:
    Link       
  55.    
  59.  
  60.  
  70.  
  72. $i=0;
  73. while ($i < $num) {
  74. $id=mysql_result($result,$i,"id");
  75. $title=mysql_result($result,$i,"title");
  76. $content_news=mysql_result($result,$i,"content_news");
  77. $forward_link=mysql_result($result,$i,"forward_link");
  78. ?>
  79.  
  81.  
  82.  
  89. $i++;
  90. }
  91.  
  92. echo "
    93. Title Content Link
    94. ";
  94. ?>
  98.  

PermaLink to this entry https://pastebin.co.uk/12166
Posted by Anonymous Sat 24th Mar 2007 04:45 - Syntax is None/text - 29 views
Download | New Post | Modify | Hide line numbers

 

Comments: 0