I have to add an index field to a database. The indexing system uses numbers categorised by points and slashed (eg for this thread, Build your site could have a top level number of 7, ss internet dev could have a second level value of 3 and php&mySQL could have a third level value of 42, resulting in the index id "7.3/42"
Any idea what the best datatype to use would be (perhaps just varchar?)
hmmm - could be being stupid here, perhaps I should break it into three fields, as I want to be able to search by all levels. If I maintained the format and included it in just one field, is there an easy way of searching for anything in just buildyoursite > SS internet dev?
Does any of this make sense ?
Where's my avatar ?