In this database I'm working with, I do NOT have a unique key for the company name, and the names end up like this with spaces between them, etc..
I want to be able to click on "Google Inc." and see all 1,926 visa applications, but what I get when I build the link is this: http://keepamericaatwork.com/?page_id=208 <http://keepamericaatwork.com/?page_id=208&occ_code=15-0000&cname=GOOGLE> &occ_code=15-0000&cname=GOOGLE I have thought about redoing the data base and adding a unique key to each one, but since it is a flat file out of a spreadsheet, I don't want to do that as I have numerous years that I have to work with once I get this going. The only thing I can think of is to do something along the lines of the old transform or whatever it was called in fox and replace the SPACE with a _ Not sure yet if PHP has such a function. Any better ideas before I dig in to this and do it the hard way? To see it in action, click on the following and then click on the quantity (pick a small qty or it will take awhile) http://keepamericaatwork.com/?page_id=53 Thanks, Virgil Company Name Number of Visas Requested <http://keepamericaatwork.com/?page_id=208&occ_code=15-0000&cname=INFOSYS> INFOSYS LIMITED 31532 <http://keepamericaatwork.com/?page_id=208&occ_code=15-0000&cname=TATA> TATA CONSULTANCY SERVICES LIMITED 8759 <http://keepamericaatwork.com/?page_id=208&occ_code=15-0000&cname=WIPRO> WIPRO LIMITED 6684 <http://keepamericaatwork.com/?page_id=208&occ_code=15-0000&cname=ACCENTURE> ACCENTURE LLP 4729 <http://keepamericaatwork.com/?page_id=208&occ_code=15-0000&cname=DELOITTE> DELOITTE CONSULTING LLP 4642 <http://keepamericaatwork.com/?page_id=208&occ_code=15-0000&cname=IBM> IBM INDIA PRIVATE LIMITED 3562 <http://keepamericaatwork.com/?page_id=208&occ_code=15-0000&cname=MICROSOFT> MICROSOFT CORPORATION 3132 <http://keepamericaatwork.com/?page_id=208&occ_code=15-0000&cname=LARSEN> LARSEN & TOUBRO INFOTECH LIMITED 3037 <http://keepamericaatwork.com/?page_id=208&occ_code=15-0000&cname=HCL> HCL AMERICA, INC. 2758 <http://keepamericaatwork.com/?page_id=208&occ_code=15-0000&cname=IGATE> IGATE TECHNOLOGIES INC. 1943 <http://keepamericaatwork.com/?page_id=208&occ_code=15-0000&cname=GOOGLE> GOOGLE INC. 1926 <http://keepamericaatwork.com/?page_id=208&occ_code=15-0000&cname=COGNIZANT> COGNIZANT TECHNOLOGY SOLUTIONS U.S. CORPORATION 1636 <http://keepamericaatwork.com/?page_id=208&occ_code=15-0000&cname=ORACLE> ORACLE AMERICA, INC. 1525 <http://keepamericaatwork.com/?page_id=208&occ_code=15-0000&cname=IBM> IBM CORPORATION 1339 <http://keepamericaatwork.com/?page_id=208&occ_code=15-0000&cname=MASTECH,> MASTECH, INC., A MASTECH HOLDINGS, INC. COMPANY 973 <http://keepamericaatwork.com/?page_id=208&occ_code=15-0000&cname=SATYAM> SATYAM COMPUTER SERVICES LTD 943 <http://keepamericaatwork.com/?page_id=208&occ_code=15-0000&cname=QUALCOMM> QUALCOMM TECHNOLOGIES, INC. 921 <http://keepamericaatwork.com/?page_id=208&occ_code=15-0000&cname=AMAZON> AMAZON CORPORATE LLC 914 <http://keepamericaatwork.com/?page_id=208&occ_code=15-0000&cname=UST> UST GLOBAL INC 868 <http://keepamericaatwork.com/?page_id=208&occ_code=15-0000&cname=MPHASIS> MPHASIS CORPORATION 797 <http://keepamericaatwork.com/?page_id=208&occ_code=15-0000&cname=TECH> TECH MAHINDRA (AMERICAS), INC. 789 <http://keepamericaatwork.com/?page_id=208&occ_code=15-0000&cname=JPMORGAN> JPMORGAN CHASE & CO. 729 Virgil Bierschwale Covering the Paradise Triangle www.ParadiseTriangle.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
