Notice: Trying to get property of non-object in /var/www/vhosts/brick.org.uk/httpdocs/index.php on line 434

Notice: Trying to get property of non-object in /var/www/vhosts/brick.org.uk/httpdocs/index.php on line 465

Notice: Trying to get property of non-object in /var/www/vhosts/brick.org.uk/httpdocs/index.php on line 465

The query could not be executed.

Query:
select p.product_id as id, product_rank as rank, 'product' as source from bda_products p where p.product_category_id = UNION ALL select r.resource_id as id, resource_rank as rank, 'resource' as source from bda_resources r where r.resource_category_id = order by rank asc

DB returned following error message:

Error number: 1064

Error message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNION ALL select r.resource_id as id, resource_rank as rank, 'resource' as sourc' at line 1


Warning: Invalid argument supplied for foreach() in /var/www/vhosts/brick.org.uk/httpdocs/index.php on line 468
PDFs/Surrey_County_Council_Paper.pdf

Publications

Select Category