[Logician]

Originally Posted by zlos

It solves the issue

I have another question, which came also from



Or ony way/solution to $WQfield in a query result? Simple SQL does not solve my issued, let me present an example:

PHP Code:

$query = "
SELECT category_id, name, parent_id
FROM categories
ORDER BY category_id, parent_id"; 


This query produces a list of categories & subcategories sorted. But I would like to format each row of the query depending on the result. For example:

PHP Code:

if ($row->parent_id > 0) //means it is a SUBcategory
{ echo "Subcategory: "; } else { echo "-- "; } 


I see, that there is a post query php code available and hope I can solve it somehow. Idea sharing is of the great help for me


BTW: I see in your documentation .doc file, that the is somewhere bigger help file for queries. Where is it exactly?

Regards
Tom

Sorry you can't do this one with webtemplates because "webquery phpinclude after" section is evaluated after all webquery data is processed, not in the middle of the compilation.

So all you can do is to use such a query:

PHP Code:

$query = "
SELECT category_id, name, parent_id
FROM categories
where parent_id > 0
ORDER BY category_id, parent_id"; 


if this is not good enough, you need to code a custom script for your goal.