[code=php]
<?php error_reporting(E_ALL ^ (E_NOTICE | E_WARNING));
ini_set(‘display_errors’,1);
$beg = ‘2004-04-15’;
$end = ‘2010-04-15’;
$dbh = mysql_connect(“host”,”username”,”password”);
$query = sprintf(”
SELECT customers_id, customers_email_address, customers_info_date_account_created
FROM db_name.customers, db_name.customers_info
WHERE customers_info_id = customers_id
AND customers_info_date_account_created
BETWEEN ‘%s’ AND ‘%s’
AND (customers_email_address LIKE ‘%.edu%’)”,
mysql_real_escape_string($beg), mysql_real_escape_string($end)
);
$result = mysql_query($query);
if (!$result) {
$message = ‘Invalid query: ‘ . mysql_error() . “<br/>n”;
$message .= ‘Whole query: ‘ . $query;
die($message);
}
$token = array();
while ($row = mysql_fetch_assoc($result)) {
#print_r($row);
$token[array_pop(explode(‘@’, $row[‘customers_email_address’]))][$row[‘customers_id’]] = $row[‘customers_email_address’];
}
var_export($token);
mysql_free_result($result);
/* Dies with error
Invalid query: Query was empty
Whole query:
*/
?>
This works fine as a query in PhpMyAdmin, but fails when I try to execute,
any errors you guys can spot in syntax I might have overlooked?? :rolleyes: