Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.

  • 14/04/2017 Happy Easter

    Wish a Happy Easter and give 30% discount for all our WordPress and Joomla! extensions. Use EASTER17 coupon code. The offer is valid till 17 April.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Deleting single entries from the results
(1 viewing) (1) Guest
ARI Quiz Lite
Go to bottomPage: 1
TOPIC: Deleting single entries from the results
#14803
Deleting single entries from the results 6 Years, 5 Months ago Karma: 0
Is there a way to delete a single entry from the results table?
I found a thread describing the way to empty out the sql table, but that clears out everything.

Cheers!
The administrator has disabled public write access.
 
#14807
Re:Deleting single entries from the results 6 Years, 5 Months ago Karma: 667
Hello,

You can use the next SQL query:

Code:


DELETE FROM
  jos_ariquizstatistics,
  jos_ariquizstatisticsinfo
USING
  jos_ariquizstatisticsinfo LEFT JOIN jos_ariquizstatistics
    ON jos_ariquizstatisticsinfo.StatisticsInfoId = jos_ariquizstatistics.StatisticsInfoId 
WHERE
  jos_ariquizstatisticsinfo.StatisticsInfoId = STATISTICS_INFO_ID



Where STATISTICS_INFO_ID is ID of necessary results. For example if ID equals to 3, use the next query:

Code:


DELETE FROM
  jos_ariquizstatistics,
  jos_ariquizstatisticsinfo
USING
  jos_ariquizstatisticsinfo LEFT JOIN jos_ariquizstatistics
    ON jos_ariquizstatisticsinfo.StatisticsInfoId = jos_ariquizstatistics.StatisticsInfoId 
WHERE
  jos_ariquizstatisticsinfo.StatisticsInfoId = 3



Regards,
ARI Soft
The administrator has disabled public write access.
 
#14885
Re:Deleting single entries from the results 6 Years, 5 Months ago Karma: 0
Thanks for the assistance.
The administrator has disabled public write access.
 
Go to topPage: 1