Page 1 of 1

Best way of doing it (2)...

Posted: Thu Dec 18, 2008 6:58 am
by oscardog
Now i have the diary sorted, using a MySQL database with a date, event and then the user_id and they submit it using a form, all fine.

Now i have also on the website a 'planner' which will have alot more entries if used properly(they can put in 'events' from 8am to midnight). So say someone properly uses this, unlike the diary which has one entry per day, this could have 17(?) entries or somewhere around there now i know MySQL databases can hold alot of data, but if it was to get popular i would need tables inside the databse as:

planner_entries1
planner_entires2
planner_entries3

Now at the start i would only need one, but once that got full(I have no idea of telling when that would be, so if anyone wants to enlighten me on when a table is full that'd be great) but when it does how would i go about then on the code, searching through both databases?

Thanks