• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: how to count multi field in php

how to count multi field in php 3 years 3 months ago #40914

  • saso
  • saso's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
mysql table my_submission_values
SubmissionIdFormIdFieldNameFieldValue
216statemystate1
216qda1myqad1
316statemystate2
316qda1myqad2

Count must be 1 because SubmissionId is same (2)
$db->setQuery("SELECT COUNT(`SubmissionId`) FROM my_submission_values
         WHERE FormId = 16 And fieldname= 'state' AND  fieldvalue ='mystate1'AND 
        `FieldName`='qda1' 
	 AND`FieldValue`='myqad1'");
         $submissions = $db->loadResult();

it means SubmissionId that same must be COUNT!
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!