how do I structure an sql query to make a dynamic activity list with the corresponding text template and
DYNAMIC VALUES for a given activity notification's type eg "
user started a thread
test thread in
General forum"
PHP Code:
$activityListq = $mysqli->query("SELECT *
FROM activitystream a
JOIN user u ON (a.userid = u.userid)
ORDER BY dateline DESC LIMIT 4");
that allows me to get the user details and then I do a query on activitystreamtype ..... but where do I find the serialized data to combine this data with and form readable sentances???