This question is rather none specific. I need to know what is the significance and usage of index in tables. What are the differences between the primary key and an index and where and how one should use these?
$quer = "SELECT fname,lname FROM directory WHERE id=34";
$query = "UPDATE table SET deleted=1"; // absence of WHERE id=34