Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function insert_interests($uid, $interests) {
- /* first, we'll delete any entries this user already has in the table */
- purge_lookup("jss_users_interests_table", $uid);
- /* now create the sql insert query */
- global $db;
- $db->query(create_checkbox_query($interests, "jss_users_interests_table", $uid));
- }
- /* helper function for insert_interests(). removes all rows in $table with $uid */
- function purge_lookup($table, $uid) {
- global $db;
- $db->query("DELETE FROM $table WHERE users_id = '".$db->escape($uid)."'");
- }
- /* helper function for insert_interests(). generates the actual SQL query */
- function create_checkbox_query($arr, $table, $uid) {
- $q = "INSERT INTO $table (users_id, subcategories_id) VALUES";
- foreach ($arr as $check) {
- $q .= " ( '$uid' , $check )" . ",";
- }
- /* remove the last comma and return */
- return substr($q, 0, -1);
- }`
- INSERT INTO jss_info_requests_table
- (users_id, provider_id, subcategories_id)
- SELECT a.users_id,
- b.provider_id, b.subcategories_id FROM
- jss_users_interests_table a,
- jss_providers_assignments_table b
- WHERE a.subcategories_id =
- b.subcategories_id AND a.users_id =
- [USERID]
Add Comment
Please, Sign In to add comment