Title: Bug
Last modified: August 21, 2016

---

# Bug

 *  [trajektorijus](https://wordpress.org/support/users/trajektorijus/)
 * (@trajektorijus)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/bug-fix-6/)
 * Hi, after submission i receive a Warning “mysql_num_rows() expects parameter 
   1 to be resource boolean given” on line 273 at sml.php.

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Thread Starter [trajektorijus](https://wordpress.org/support/users/trajektorijus/)
 * (@trajektorijus)
 * [12 years, 1 month ago](https://wordpress.org/support/topic/bug-fix-6/#post-4905339)
 * Here’s my approach:
 * // Handle form Post
    if ($_POST[‘sml_subscribe’]) { $name = $_POST[‘sml_name’];
   $email = $_POST[‘sml_email’]; if (is_email($email)) {
 *  $exists = $wpdb->get_results(“SELECT * FROM “.$wpdb->prefix.”sml WHERE sml_email
   LIKE ‘”.$wpdb->escape($email).”‘”);
 *  if (count($exists) < 1) {
    $wpdb->query(“insert into “.$wpdb->prefix.”sml (sml_name,
   sml_email) values (‘”.$wpdb->escape($name).”‘, ‘”.$wpdb->escape($email).”‘)”);}}}
 *  [vitalik1921](https://wordpress.org/support/users/vitalik1921/)
 * (@vitalik1921)
 * [12 years ago](https://wordpress.org/support/topic/bug-fix-6/#post-4905539)
 * Use:
 *     ```
       if ($_POST['sml_subscribe']) {
       	$name = $_POST['sml_name'];
       	$email = $_POST['sml_email'];
       	if (is_email($email)) {
   
       		$count = $wpdb->get_var("SELECT COUNT(*) FROM ".$wpdb->prefix."sml where sml_email like '".$wpdb->escape($email)."' limit 1");
       		if ($count <1) {
       			$wpdb->query("insert into ".$wpdb->prefix."sml (sml_name, sml_email) values ('".$wpdb->escape($name)."', '".$wpdb->escape($email)."')");
       		}
       	}
       }
       ```
   

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Bug’ 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/)

 * 2 replies
 * 2 participants
 * Last reply from: [vitalik1921](https://wordpress.org/support/users/vitalik1921/)
 * Last activity: [12 years ago](https://wordpress.org/support/topic/bug-fix-6/#post-4905539)
 * Status: not resolved