View source for Add, delete, modify mysql data with php

insert example 1:
  $query = "INSERT INTO ineedlist VALUES ('','$name','$type','$user','$strikethrough')";
  mysql_query($query);

change example 1:    
          $update=mysql_query("UPDATE ineedlist SET strikethrough='1' WHERE id='$astrikethrough[$i]'") 
          or die (mysql_error());
	
delete example 1:
          $update=mysql_query("DELETE FROM ''dbasename'' WHERE var='value'") 
          or die (mysql_error());

delete example 2:
          $update=mysql_query("DELETE FROM ineedlist WHERE id='$astrikethrough[$i]'") 
          or die (mysql_error());

[[category:php]]