What is the best way to import information from items of different types in other sections, but by the same user. E.g. Is it possible to have the favorite car of an author listed underneath their article?
For now I am using MySQL in a template witch gives me something like {"18":"Fiat panda","5":"Alwin"}
And I would like to convert this to 'Fiat panda'
$bestuurderid = $item->user_id;
$result = mysqli_query($con,"SELECT * FROM WLHjm_js_res_record WHERE user_id=$bestuurderid AND section_id=2 ");
Question
Announcement
Conversation
Idea
Praise
Problem
Solved
Open
What is the best way to import information from items of different types in other sections, but by the same user. E.g. Is it possible to have the favorite car of an author listed underneath their article?
For now I am using MySQL in a template witch gives me something like {"18":"Fiat panda","5":"Alwin"}
And I would like to convert this to 'Fiat panda'
$bestuurderid = $item->user_id;
$result = mysqli_query($con,"SELECT * FROM WLHjm_js_res_record WHERE user_id=$bestuurderid AND section_id=2 ");
$row = mysqli_fetch_array($result);
echo $row['fields'];