asked on
$query2 = "
SELECT
DISTINCT ev.EVENT AS EVENT
FROM TXT2GIVE_EMAIL_EVENT$emailTableNum ev
WHERE ev.CHARITY_ID='$charityId' AND ev.CAMPAIGN_ID='$campaignId' AND ev.EMAIL_SAVE_ID='$saveId' AND ev.EMAIL_ADDRESS='$email' AND ev.EMAIL_SAVE_ID IN (SELECT EMAIL_SAVE_ID FROM TXT2GIVE_EMAIL_SENT WHERE ev.CHARITY_ID='$charityId')
ORDER BY TIMESTAMP ASC";
$result2=mysql_query($query2, $db) or die(mysql_error());
if(mysql_num_rows($result2))
{
$stmt = new Database();
$query = "SELECT
DISTINCT ev.EVENT AS EVENT
FROM TXT2GIVE_EMAIL_EVENT$emailTableNum ev
WHERE ev.CHARITY_ID = :clientID AND ev.CAMPAIGN_ID = :campaignID AND ev.EMAIL_SAVE_ID = :saveID AND ev.EMAIL_ADDRESS = :email AND ev.EMAIL_SAVE_ID IN (SELECT EMAIL_SAVE_ID FROM TXT2GIVE_EMAIL_SENT WHERE ev.CHARITY_ID = :clientID)
ORDER BY TIMESTAMP ASC";
$stmt->query( $query );
$stmt->bind( ':clientID', $clientId );
$stmt->bind( ':campaignID', $campaignId );
$stmt->bind( ':saveID', $saveId );
$stmt->bind( ':email', $email );
$stmt->execute();
$result = $stmt->all();
if(mysql_num_rows($result2))
PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.
TRUSTED BY
Open in new window
PDOStatement::rowCount
http://php.net/manual/en/pdostatement.rowcount.php