need help i dont really know how to do this

[dean012]

1.      Set up a website to display proverbs for people who might be in need of encouragement or wise words. Think about the colours (representing happiness, prosperity, goodness and love etc). Think about an image (lots of cultures – but don’t spend time creating one at this stage).

2.      Create a log in for your friends only (later on they will be able to add proverbs). If you wish use the same password and whisper it to them. This is to enable your friends (whom you should trust) to add to your proverb database whilst protecting your database from outsiders (whom you should distrust).

3.      Use provided data files (proverbs and countries) to set up a database. There are a few ; errors which should be corrected so it will not insert correctly into the database. NOTE: poor basic design eg Scottish listed many times …  don’t worry about correcting this … 62 000 entries would take forever!

4.      Test that your database is working by creating queries such as: (1) view proverbs from a particular country. (2) randomise the proverbs from a particular country but print a limited number eg 1 or 10.
SELECT proverb FROM proverbs WHERE origin = “Scottish” ORDER BY RAND() LIMIT 10;
(3) proverbs about money, love etc.

5.      Connect the database, re-run the queries to check everything is working.

6.      Add two Maori proverbs and delete a proverb. Test by re-running your queries.

7.      Ask two of your select group to sign in and add a proverb.

8.      Comment your code.1.      Set up a website to display proverbs for people who might be in need of encouragement or wise words. Think about the colours (representing happiness, prosperity, goodness and love etc). Think about an image (lots of cultures – but don’t spend time creating one at this stage).

2.      Create a log in for your friends only (later on they will be able to add proverbs). If you wish use the same password and whisper it to them. This is to enable your friends (whom you should trust) to add to your proverb database whilst protecting your database from outsiders (whom you should distrust).

3.      Use provided data files (proverbs and countries) to set up a database. There are a few ; errors which should be corrected so it will not insert correctly into the database. NOTE: poor basic design eg Scottish listed many times …  don’t worry about correcting this … 62 000 entries would take forever!

4.      Test that your database is working by creating queries such as: (1) view proverbs from a particular country. (2) randomise the proverbs from a particular country but print a limited number eg 1 or 10.
SELECT proverb FROM proverbs WHERE origin = “Scottish” ORDER BY RAND() LIMIT 10;
(3) proverbs about money, love etc.

5.      Connect the database, re-run the queries to check everything is working.

6.      Add two Maori proverbs and delete a proverb. Test by re-running your queries.

7.      Ask two of your select group to sign in and add a proverb.

8.      Comment your code.

im stuck from number 2

[KevinM1]

Yeah... we don't answer homework questions.

[Maq]

Good luck with that.

[jcbones]

I answer homework questions WHEN there has been an effort put forth, and you are stuck on a CODING issue.  I'm not going to do it for you.  If you are stuck at basic if/else statements, you should hit up the instructor. There is an obvious breakdown in your classroom instruction.