Need some help with 2 problems. First is with a MySQL query. I did not design these tables and can't change them.
Table 1:
ItemID, Description
Table 2:
CustomerName, Orders
Orders in Table 2 contains ItemID in this format 1, 4, 10, 45
Where every new order gets appended to the field.
I need a query to show CustomerName ordered items: Description1, Description 4, Description10, ....
Any ideas on how to write the query?
Second thing is more of a question. I have a Perl script that contains a number of functions I can use. Can I call the functions from a PHP script passing arguments to the Perl functions? What I need to do is to call a function in a loop passing it two arguments each time through the loop.
Thanks!
-James
