Editing Mika/Notes/Computer Stuff (section)

=PHP=

'''Problem:'''

Again, I was doing [http://php5.seesaa.net/category/4118446-1.html this tutorial]. I got the update/delete working but not insert. Even when I typed in the values, it returned Missing Values.

'''Solution'''

I said name="id" in select3.php in the form part for insert3.php but I said _POST[ID] in insert3.php. I changed it to id and it works fine now.

----

'''Problem:'''

I was doing [http://php5.seesaa.net/category/4118446-1.html this tutorial]. First of all, I didn't quite write down the codes right:

* incorrect update/delete versions linked from select.php
* <?= is good <? = is not good 
* _GET['X'] is good but _GET["X"] is not good.
* Don't free memory in the php that is required_once

After fixing all these, I got:

"failed query"
SQL:SELECT Name WHERE ID =

'''Solution'''

Since I got the same message for both update and delete, I figured that the problem was elsewhere. I looked at select3 and after update3.php? I said id= instead ID= . I capitalized the id for bother update3 and delete3 and it works fine now.