query database

[kallis]

hi,

currently i am using two different databases.
Table A in database A contain customer information
Table B in database B contain customer problem

When I insert a query condition to find for a list of customer whom age is more then 20 from table A. The list is stored in an array in PHP so that the list can be used to find the customer problem from table B. I wants the problem to be sorted accordingly.

I am wondering if i am able to throw a list of customer into an sql query and order the problem accordingly? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[CPM]

You shouldn't have two databases then. If the information in Table A and Table B are related then they belong in the same database and not separate databases.

cheers
Bye -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --