Database Normalisation - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23) +--- Thread: Database Normalisation (/showthread.php?tid=22268) |
Database Normalisation - El Forum - 09-03-2009 [eluser]georgerobbo[/eluser] Hello, I need some help with database normalization. Basically I have five/eight pages where content will be brought down from a database. I'm not sure if the way I've set it out is the most efficient way of doing things. I have all the results grouped into a table Quote:ID Object_ID Value I am then using a MYSQL WHERE statement to use the Object_ID to determine which page the result is displayed on. Is there a better way of doing this? Thanks Database Normalisation - El Forum - 09-03-2009 [eluser]Phil Sturgeon[/eluser] No, you have no more data that needs to be normalised. I would recommend giving your fields more meaningful names though. Try: Quote:id, uri, body or: Quote:id, slug, content Database Normalisation - El Forum - 09-03-2009 [eluser]georgerobbo[/eluser] Those were just for example. I'm using different names for them. Thanks very much though. |