database eot search script?

Hello. I’m looking for a script to search the database for member eot dates.
I have a script I want to run but I first need to search for the current members eot dates.

something like..

$USER_EOT_DATE = global($s2member_eot_date)
if ($USER_EOT_DATE = ("+30 DAYS", 'CURRENT DATE')) {
	[RUN MY SCRIPT]
}

is there a script or variable that searches all the members eot dates?

You’ll need something like this.

global $wpdb;

$query = "SELECT `user_id`, `meta_value` FROM `wp_usermeta` WHERE `meta_key` = 'wp_s2member_auto_eot_time' AND `meta_value` != ''";

foreach($wpdb->get_results($query) as $result)
	echo $result->user_id.' EOT Time = '.$result->meta_value."\n";

Thank you for your reply.

So how would I use this if trying to implement an if statement like..

(wordpress eot date search)
if (wp_s2member_auto_eot_time >= “31 July 2014”) {
blah blah blah
}

global $wpdb;

$query = "SELECT `user_id`, `meta_value` FROM `wp_usermeta` WHERE `meta_key` = 'wp_s2member_auto_eot_time' AND `meta_value` != ''";

foreach($wpdb->get_results($query) as $result)
	if (wp_s2member_auto_eot_time >= "31 July 2014" {
	    [do this action]
	}

..would that be correct? lets say the action is sending an e-mail. would the e-mail send? (assuming the e-mail code is correct of course)