07-28-2016, 10:59 AM
I'm not an expert when it comes to complicated queries. That might be a better question for StackOverflow. The great thing about the database classes with userspice is that although there are tools to write quicker update, delete, insert, etc you can always write just a generic query that is not userspice specific.
So, if you want to assign your query a variable, you just do
$myQuery=$db->query("Your Query Here"); //you can also just run it without assigning a variable
BUT you can also format your results based on what you want back.
Do you want only the first one result?
$answer=$myQuery->first();
Do you want all the results as an object?
$fullAnswer=$myQuery->results();
The great news is that whatever is in your quotes for your query is just normal SQL...not userspice specific.
So, if you want to assign your query a variable, you just do
$myQuery=$db->query("Your Query Here"); //you can also just run it without assigning a variable
BUT you can also format your results based on what you want back.
Do you want only the first one result?
$answer=$myQuery->first();
Do you want all the results as an object?
$fullAnswer=$myQuery->results();
The great news is that whatever is in your quotes for your query is just normal SQL...not userspice specific.