[Resolved] cformsII php mysql help!

Hello everyone,
i’m not a database hard coder, but i love wordpress so i’d like to know more.i’m using wordpress + cformsII for a school website.
i have a form for each lesson, so students can subscribe to single lessons, and i have to manage a maximum number of students registrations, different for each lesson.
so in the plugin backend i’ve set a maximum number of submission different for each form resulting in a “Registrations are closed” sentence after the number of submission is reached.but now i’d love to have a counter for the number of seats left, such as “There are 2 more seats left, hurry up!”
i didn’t find an automatic way to do this so i’m trying to do a query directly on the database and having a numerical result to show on the page.i’ve found that the number of submissions is stored in the new table
wp_cformssubmission
underform_id
and the maximum number of submission set is stored in the tablewp_cformsdata
underfield_val
wherefield_name
is “Set the maximum number of students” andsub_id
is the number of the lesson.so now, math should be simple: (maximum number students) – (registrations) = (number of seats left)
but my poor knowledge of MySQL won’t help me in getting the query works…
i tried different ways starting from here http://codex.wordpress.org/Function_Reference/wpdb_Class but i’m stuck.any help?
thank you in advance.alessandro
 The topic ‘[Resolved] cformsII php mysql help!’ is closed to new replies.