bradthor
12-23-2015, 07:26 PM
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"
$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???
$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???