I am hoping someone would be able to point me to the right direction for solving my problem.
I wish to type a part number and make php fetch its corresponding price from a mysql database. The database will have list of part number with its prices.
The problem that I have is that I need to do this several thousand times.
The part numbers, at the moment, are in a quarkxpress table, which can be converted to text and then extracted to just simple text, one item on a line.
ideally i would like to convert the table to text and make PHP fetch the prices , say 50, item at a time.
i appreciate your help in advance.