I am a noob when it comes to pulling data from tables and fields of a WP database so I'll explain it as best as I can without it running into a thesis.

I have a table called WP_answer.

In that table are multiple fields, but the 2 I want info from are "QST_ID" and "ANS_Value"

QST_ID contains 5 ID numbers, 11,12,13,14 & 15

They Correlate as follows:

  • 11 would equal question: Year
  • 12 would equal question: Make
  • 13 would equal question: Model
  • 14 would equal question: Engine
  • 15 would equal question: Class

The ANS_Value already lines up with the QST_ID as submitted on the form. BUT because there will be close to 900 forms submitted that contains the 5 questions, that's a boat load of data.

How can I pull this data, put it into 5 columns on a current WP Page, and have each column header have the correct data name and for it to paginate after say 75 entries? I think I am making this more complicated that it is but after working 70 hours a week, my brain hurts anyways.

I appreciate any feedback and help that you guys give :)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.