Results 1 to 3 of 3
  1. #1
    Join Date
    September 23rd, 2013
    Technical Question - PHP / SQL
    Hi All,

    I wondered if anyone could help with the following:

    I have a field ("features") in my "desc_lookup" table with keywords in it, these are separated by comma.

    What I want to do is check the "description" field in my "products" table against the keywords.

    If the desciption contains any of the keywords put that keywords in the "features" field in "products"


    Table: desc_lookup
    Field: Features.
    Data. "chrome surface,1.5m long,18 Volt, 5 year guarantee"

    Entry in my products table:
    Desciption: "Hand pliers with chrome surface, comes with 5 year guarantee"

    So I would like in my "keywords" field "chrome surface,5year guarantee"

    Because both of the words "Chome suface" and "5 year guarantee" are found in the description.

    I am using the following (which works) but I have 3,000 keywords to check against 100,000 products so it's taking too long to run and causing many timeouts.
    $features = explode("\n",$_POST["features"]);
    $features = str_replace("\r","",$features);
    foreach($features as $feature)
        $sql = "UPDATE `".$config_databaseTablePrefix."products` 
               SET features = CONCAT(features, '".$feature.",') WHERE `description` LIKE
    Thanks in advance!


  2. #2
    ...and a Pirate's heart. Convergence's Avatar
    Join Date
    June 24th, 2005
    Hey Chris,

    Sent you an email...
    Salty kisses, Sandy toes, and a Pirate's heart...

  3. Thanks From:

  4. #3
    Join Date
    September 23rd, 2013
    Cheers Convergence - Reply sent

  5. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Technical question on tracking
    By hazlcha in forum Commission Junction - CJ
    Replies: 2
    Last Post: September 12th, 2006, 08:04 PM
  2. Technical Question!!!!!! Please help!!!!!
    By master_watchmaker in forum ShareASale - SAS
    Replies: 5
    Last Post: June 12th, 2004, 06:48 PM
  3. Technical SEO question...
    By eggerda in forum Search Engine Optimization
    Replies: 1
    Last Post: July 24th, 2003, 10:34 AM
  4. Technical CJ Cookie question
    By br33526 in forum Commission Junction - CJ
    Replies: 16
    Last Post: October 30th, 2002, 11:32 AM

Tags for this Thread

Posting Permissions

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