Hi there... I bought Kev's book, and it's been real helpful so far... picking up on SQL and PHP quite fast for not having programmed b4.
Anyhow, I need to design a database to track Daily Specials at a friends restaurant. There will be between 6 and 9 specials a day, and each special needs a description in english and spanish plus a price. In addition I want to upload the specials to their website every day.
I was thinking of making one table and having the three fields per special for a maximum of nine specials, which would give me 27 fields per row... plus one field for date (and maybe a unique ID, or could i use the date for this?).
Is this the right way to go about things?
Or is there a better solution? I also need to print the specials for the menus every day, I heard you can do some pretty kewl things with PDFs and PHP... or should I just stick to HTML?