Title: mysql_query problem
Last modified: August 30, 2016

---

# mysql_query problem

 *  Resolved [inpariswithyou](https://wordpress.org/support/users/inpariswithyou/)
 * (@inpariswithyou)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/mysql_query-problem/)
 * Relates to [this other issue](https://wordpress.org/support/topic/not-working-with-latest-wordpress-version)…
 * Line 272 of the sml.php file uses mysql_query, which is deprecated, and causes
   MySQL errors to pop up on the page.
 * I fixed this changing lines 272-274 to this:
 *     ```
       $exists = $wpdb->query("SELECT * FROM ".$wpdb->prefix."sml where sml_email like '".$wpdb->escape($email)."' limit 1");
       if ($exists < 1) {
       	$wpdb->query("insert into ".$wpdb->prefix."sml (sml_name, sml_email) values ('".$wpdb->escape($name)."', '".$wpdb->escape($email)."')");
       }
       ```
   
 * You may want to incorporate a fix into the actual plugin, so this problem doesn’t
   persist for other people.
 * [https://wordpress.org/plugins/mail-subscribe-list/](https://wordpress.org/plugins/mail-subscribe-list/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [Garrett Grimm](https://wordpress.org/support/users/grimmdude/)
 * (@grimmdude)
 * [9 years, 7 months ago](https://wordpress.org/support/topic/mysql_query-problem/#post-8356881)
 * Hi There,
 * This has been fixed in version 2.1.3
 * -Garrett

Viewing 1 replies (of 1 total)

The topic ‘mysql_query problem’ is closed to new replies.

 * ![](https://ps.w.org/mail-subscribe-list/assets/icon-128x128.png?rev=1158481)
 * [Mail Subscribe List](https://wordpress.org/plugins/mail-subscribe-list/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/mail-subscribe-list/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/mail-subscribe-list/)
 * [Active Topics](https://wordpress.org/support/plugin/mail-subscribe-list/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/mail-subscribe-list/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/mail-subscribe-list/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Garrett Grimm](https://wordpress.org/support/users/grimmdude/)
 * Last activity: [9 years, 7 months ago](https://wordpress.org/support/topic/mysql_query-problem/#post-8356881)
 * Status: resolved