Hi. Could someone tell me how to merge these two queries into one?
It's in PHP format to give you an idea what I'm doing.
$query = "
SELECT id FROM `trackReferrers` WHERE `cookie_id`='$cookieID'
ORDER BY `timestamp` DESC LIMIT 1";
$result = mysql_query($query, $this->_dbConn);
$row = mysql_fetch_assoc($result);
$query2 = "
UPDATE `trackReferrers` SET `bool_converted`=1 WHERE `id`='$row[id]'";