array(4) {
[0]=>
array(4) {
["file"]=>
string(47) "/home/ambershop/includes/functions/database.php"
["line"]=>
int(44)
["function"]=>
string(12) "tep_db_error"
["args"]=>
array(3) {
[0]=>
&string(705) "SELECT *
FROM
`products`
INNER JOIN `products_description` ON (`products`.`products_id` = `products_description`.`products_id`)
INNER JOIN `products_to_categories` ON (`products_description`.`products_id` = `products_to_categories`.`products_id`)
INNER JOIN `manufacturers` ON (`products`.`manufacturers_id` = `manufacturers`.`manufacturers_id`)
WHERE products_description.products_name LIKE '%Amber%' OR products_description.products_name LIKE '%Horse's%' OR products_description.products_name LIKE '%Head%'
ORDER BY products_to_categories.categories_id,`manufacturers`.`manufacturers_name`, products_description.products_name
LIMIT 100"
[1]=>
&int(1064)
[2]=>
&string(199) "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 's%' OR products_description.products_name LIKE '%Head%'
"
}
}
[1]=>
array(4) {
["file"]=>
string(40) "/home/ambershop/includes/search_food.php"
["line"]=>
int(89)
["function"]=>
string(12) "tep_db_query"
["args"]=>
array(1) {
[0]=>
&string(705) "SELECT *
FROM
`products`
INNER JOIN `products_description` ON (`products`.`products_id` = `products_description`.`products_id`)
INNER JOIN `products_to_categories` ON (`products_description`.`products_id` = `products_to_categories`.`products_id`)
INNER JOIN `manufacturers` ON (`products`.`manufacturers_id` = `manufacturers`.`manufacturers_id`)
WHERE products_description.products_name LIKE '%Amber%' OR products_description.products_name LIKE '%Horse's%' OR products_description.products_name LIKE '%Head%'
ORDER BY products_to_categories.categories_id,`manufacturers`.`manufacturers_name`, products_description.products_name
LIMIT 100"
}
}
[2]=>
array(4) {
["file"]=>
string(35) "/home/ambershop/includes/footer.php"
["line"]=>
int(49)
["args"]=>
array(1) {
[0]=>
string(40) "/home/ambershop/includes/search_food.php"
}
["function"]=>
string(7) "require"
}
[3]=>
array(4) {
["file"]=>
string(32) "/home/ambershop/product_info.php"
["line"]=>
int(363)
["args"]=>
array(1) {
[0]=>
string(35) "/home/ambershop/includes/footer.php"
}
["function"]=>
string(7) "require"
}
}
1064 - 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 's%' OR products_description.products_name LIKE '%Head%'
SELECT *
FROM
`products`
INNER JOIN `products_description` ON (`products`.`products_id` = `products_description`.`products_id`)
INNER JOIN `products_to_categories` ON (`products_description`.`products_id` = `products_to_categories`.`products_id`)
INNER JOIN `manufacturers` ON (`products`.`manufacturers_id` = `manufacturers`.`manufacturers_id`)
WHERE products_description.products_name LIKE '%Amber%' OR products_description.products_name LIKE '%Horse's%' OR products_description.products_name LIKE '%Head%'
ORDER BY products_to_categories.categories_id,`manufacturers`.`manufacturers_name`, products_description.products_name
LIMIT 100 product_info.php [TEP STOP]
