multi tables - splitting string of data?

[sgtpepper]

Hello,

I hope I can explain this correctly...so here goes.

I have two tables.....one that says residential and one that is features.

In the residential table there is a field called 'features'. The features field contains 255 characters.

Now, the features 'table' has two fields....one field containing a three digital code...and one field that is the text of this code.

For example:

A03 -- Cape

If you take the string of 255 characters - every three digits matches a three digital code in the features table.

Follow me? - Ok...so now...the question....

How in the heck can I get php to read the 255 character string, chop it into three digits at a time, cross reference the featires table and display the results?

MAN! This seems difficult for a beginner....I would appreciate all the help I can get!

[Pig]

Your data is not normalized. Create a seperate table with residential id's and feature ids. so if you have 13 features in your residential listing, you would have 13 entries in the new table, and there would be none listed in your residential table. Then you just do a join to get the information from all 3 tables.