2013 may 05 : starting to learn php

8:00 PM => I started learning php from a tutorial of netbeans.link of the tutorial is https://netbeans.org/kb/docs/php/wish-list-lesson2.html.
here i learnt the following

1. downloaded netbean
2. downloaded jdk and installed
3. downloaded wamp and installed

 9:00 PM => started database connectivity through mysql jdbc in netbeans .

1. created table of wishers
2. created table of wishes
3. inserted data in tables
4. created simple form and posted its value on next page

 ERROR : I had the following errors

CREATE TABLE wishes2(
 id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
 wisher_id INT NOT NULL,
 description CHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
 due_date DATE,
 FOREIGN KEY (wisher_id) REFERENCES wishers2(id)
)

1. Error code 1005, SQL state HY000: Can't create table 'saqi.wishes2' (errno: 150)
   Line 1, column 1

• Solution : error was becuase i did not create the parent table for which i was creating a foreign  key and wishers2 table

10:00 PM