In mySQL I am making a database of pictures. I'm putting the title and the date into mySQL and I keep running into a problem.
mysql> INSERT INTO Pictures SET
-> Title = ""Priceless: George W Bush"",
-> Pdate = "2001-03-01";
The reason I'm using double quotation marks is becuase when I pull the title out into a web-page with PHP I want it to appear like:
"Priceless: George W Bush" 2001-03-01
Is the code not working because I have the double quotation marks?
Now my next question, this one should be very easy
In the date format: 0000-00-00 the first four zeros is the year, but what about the other two? Is the middle two zeros the day or the last two zeros the day? I just don't want to get the day and the month switched around
I started learning mySQL yesterday so sorry if these are super easy questions.