retrieving data from mysql

[jimwp]

Hello,

I have a field in one table with several regular data fields and the last field has data such as 1|23|34|45 and the number corrospond to values in another table. The second table would have two fields one with the number and the second field would have the value.

I need to be pointed in the right direction as how to query the data and display the results. If you need more information please let me know. It is important that I get this figured out.

Thank you

[tomhath]

Do you have the option of redesigning the tables? The old trick of putting an array into a database field will always cause this kind of headache.

If you can't use the dbms the way it should be used, just treat the tables like a text file (obviously this was designed by someone who was thinking of files rather that databases). Read a row (line from the file) look for the link in the other table (file).

[jimwp]

"Do you have the option of redesigning the tables? "
I can redesign the database tables. My input data comes to me in a txt file. I have no way of getting it formatted differently.

Thanks