Results 1 to 2 of 2
  1. #1
    Join Date
    May 23rd, 2005
    Question Making a large table from many small ones
    I am using the php script featured on the forum for import from shareasale to mysql. Its working great however, I was wondering how I would make a full text indexed (including description and product) table from all the merchants that I promote to have a large "virtual mall". I was going to use a merge table but from what I have gathered I cannot have the text fields on the merge table indexed and therefore cause problems with search results. Is this correct? Am I on the right track or should I just use a join or other SQL query for each table?
    I appreciate any info anyone can share on this subject.

  2. #2
    ABW Ambassador PatrickAllmond's Avatar
    Join Date
    September 20th, 2005
    You would use a JOIN to join the tables left to right. The main table would have a foreign key (usually numeric) over to the joined table.

    More than likely you would use a UNION statement to join them top to bottom.

    This response was masterly crafted via the fingers of Patrick Allmond who believe you should StopDoingNothing starting today.
    Focus Consulting is where I roll | Follow @patrickallmond on Twitter
    Search Engine Marketing | Search Engine Optimization | Social Media | Online Video

  3. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Anyone making large amounts though affiliates
    By 24hourapartments in forum Midnight Cafe'
    Replies: 10
    Last Post: March 5th, 2010, 04:57 AM
  2. making new/large shirt site...
    By vcdshirts in forum Midnight Cafe'
    Replies: 0
    Last Post: February 25th, 2009, 11:24 PM
  3. Small vs.large merchants and return days
    By webworker in forum Midnight Cafe'
    Replies: 6
    Last Post: November 20th, 2006, 03:24 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts