Support MYSQL functions?

  • Resolved karthikreddy442

    (@karthikreddy442)


    11 years, 2 months ago

    Hi,

    Does the MYSQL query support the substring and concat function of MYSQL?
    I am trying to insert substrings of 3 entries in the database as an entry into a column.

    INSERT INTO COURSE_REVIEW (REVIEW_ID, COURSE_COMBINATION, COMBINATION_REVIEW, COMBINATION_RATING) VALUES (“{2}”, CONCAT(SUBSTRING({6},1,8),SUBSTRING({6},1,8),SUBSTRING({6},1,8)), “{5}”, “{2}”)

    https://ww.wp.xz.cn/plugins/form-maker/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor webdorado

    (@webdorado)

    11 years, 2 months ago

    Dear karthikreddy442,

    This should work, but use the query below during the process:

    INSERT INTO COURSE_REVIEW (REVIEW_ID, COURSE_COMBINATION, COMBINATION_REVIEW, COMBINATION_RATING) VALUES (“{2}”, CONCAT(SUBSTRING(“{6}”,1,8),SUBSTRING(“{6}”,1,8),SUBSTRING(“{6}”,1,8)), “{5}”, “{2}”)

    Thread Starter karthikreddy442

    (@karthikreddy442)

    11 years, 2 months ago

    Hi thanks for the quick reply:

    One more question I have is what is the best way to display information from the database on a page?

    Is there a way to set form action= *.php to call the php on user hitting submit?

    Plugin Contributor webdorado

    (@webdorado)

    11 years, 2 months ago

    Dear karthikreddy442,

    We do have only front-end submission display option with the Form Maker available with the Pro version. This will though display all submitters’ data. There is no other easy way of displayig the submissions on the front end. Thank you.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Support MYSQL functions?’ is closed to new replies.