sql + redicet

Discussion in 'Песочница' started by brown, 17 Dec 2016.

  1. brown

    brown Member

    Joined:
    16 Oct 2016
    Messages:
    189
    Likes Received:
    8
    Reputations:
    1
    помогите крутануть sql,пробую руками)(впервые).Но вот тут то не задача при добавлении в адресную строку любой буквы или цифры происходит редикет на гл.страницу.
    пробую так:
    site/test/1'.htm
    выходит ошибка
    Code:
    Error: syntax: select sql_no_cache id,ts,category_id,name,generic_name,bestseller,bestseller_weight, ((pricePerItem/100)*-6)+pricePerItem AS pricePerItem, type_de AS type, shortDescription_de AS shortDescription, productDescription_de AS productDescription, safetyInformation_de AS safetyInformation, sideEffects_de AS sideEffects FROM store_products WHERE name LIKE '1' union select sql_no_cache 1,2,3,4,5,6,7' LIMIT 1 -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 '' LIMIT 1' at line 7
    если так
    site/test/1 union select 1,2,3,4,5,6,7.htm
    редикет