PHP/MySQL query ?
PHP/MySQL query ?
Out of context: Reply #6
- Started
- Last post
- 10 Responses
- unfittoprint0
create a table named categories [4 ie], each record should have unique ID [1,2,3,4]. Add a 'name' field to the table, to identify each category [ID1's name = Flash, ID2's name = Static...]...
Then create a table with your work items [ie. folio]. Each record should contain [besides of an auto-increment unique ID, like in the example above], a name, description and a number relating to the cateogory it belongs: in table folio, a record for a flash site should have as categoryID the same number used in by the category Flash in the categories table.
NT's PVN forum uses the same logic. Connections between tables are the core of complex database driven sites.
A good read: http://www.amazon.com/exec/obido…