Hey guys, I hired someone to create me a delayed autoresponder script. He's nowhere to be found and the script only works sometimes. I open up the error_log and get these 2 errors.

PHP Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/****/public_html/email/autoresponder.php on line 44

PHP Parse error: syntax error, unexpected T_IF in /home/*****/public_html/email/autoresponder.php on line 45

This is from line 40-50. Please let me know if I should include more, thanks in advance.

function PutInTheQueue($email)
{
	global $database;
	if (mysql_fetch_row(mysql_query("select * from {$database['table']} where `account`=".mslash($email['account'])." AND message_id=".mslash($email['message_id']))))
		return true;//already in queue
	$email['duetime'] = date("Y, m, d, H, i, s",$email['duetime']);
	return mysql_query(InsertSQL($database['table'],$email));
}
//------------------------------------------------------------------------------
function mslash($s)
	{

    try this. at least you will be able to see what (if any) error mySQL is spitting back

    function PutInTheQueue($email)
    {
    	global $database;
    
    $result = mysql_query('SELECT COUNT(*) AS count FROM ' . $database['table'] . " WHERE account = '" . mslash($email['account']) . "' AND message_id = '" . mslash($email['message_id'] . "'") or exit(mysql_error());
    if (mysql_result($result, 0))
    {
    	return true; //already in queue 
    }
    else
    {
    	$email['duetime'] = date('Y, m, d, H, i, s', $email['duetime']);
    	$result_insert = mysql_query(InsertSQL($database['table'], $email)) or exit(mysql_error());
    	return $result_insert;
    }
    }
    
      Write a Reply...