thegladiator

I have an excel spreadsheet that I can enter into a table and manipulate far faster in MySQL. The issue is that the rows are Duplicated. The structure is shown below. Part Number | Description | Qty | Cost | OEM Resale ABC | Switch | 1 | 1.00 | 3.5 ABC | Switch |25 | 1.00 | 2.75 Desired Result Part Number | Description | Qty1 | Cost1 | OEM Resale1 | Qty2 | Cost2| Resale2 I would like to have them in separate columns. I'm using phpmyadmin to write my querys. Is this at all possible? The best i've seen is the concat function which once i get past description would put all remaining data into one field that has been comma separated. I could do that and transfer back to excel. I ask as the file that I'm using is 30K+ rows and the coworker i'm setting this up for gets this file in the same format to evaluate about 5 times a year thanks c

Gents, thanks for your collective helps. What I'm hoping i can derive is a solid base in implementing / understanding the DOM tools initially so that I no longer have to ask. The concept of screen scraping / data mining is one that I can visualize in theory, just now sure about how to begin making it work with code thanks coleman

Salathe, this is my first endeavor no matter the language for scraping. I said that I have taught myself other languages as i can pick up concepts quickly. What I am after help wise is the concept of scraping sites as it pertains to PHP. I'm assuming the logical thought process would be to attack the source code for the sites i've listed, however i have no idea where to actually begin. thanks

I am in the process of teaching myself PHP/MySQL. I have taught myself other programming languages in the past so its not that i can't learn. but as i'm new and trying to learn both at the same time, i'm needing some help with php / mysql to datamine either of the following sites. www.findchips.com www.eciaauthorized.com WHat i want to do is after putting in the part number, for each distributor that returns data i want to extract the following data for each distributor Quantity Break Resale at quantity break Current Stock I want to write the data into a field in the database that holds the p/n's and my company's resale. I'm wanting to do this as an exercise so that i can dynamically benchmark my resales against that of my competitors. To get a feel of the data that is returned, please use the following p/n. 1n4001-e3/54 any and all help would be greatly appreciated