Answer the question
In order to leave comments, you need to log in
Sphinx: How to make a query correctly?
There was a problem with the site. The variable is not escaped. '@name "' . $value . '"';
If you submit to value = 1" then an error will pop up
SELECT
COUNT(*) as `count`,
@groupby, IF(cetime > 1443953076, IF(cprice > 0, 2, 1), 0) AS ck
FROM
aa_index
WHERE
activity_id = 298
AND MATCH('@name "1""')
GROUP BY company
ORDER BY
ck DESC,
cprice DESC
LIMIT
0, 100000
OPTION
max_matches = 100000
index aa_index_delta,aa_index_main: syntax error, unexpected $end near ''
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question