Alternate sql query

Questions › Alternate sql query

Felix Lugaru asked 12 years ago

Hello!
I use complex sql queries to retrieve data. In this case, an attempt to sort or search the data in the table leads to sql errors.
How can I specify an alternate sql query to sort by the desired field?

7 Answers

0 Vote Up Vote Down

Abu Ghufran answered 12 years ago

Hello,

If you can email me the SQL, it would help in suggesting an alternate.

Awaiting for reply.

0 Vote Up Vote Down

Felix Lugaru answered 12 years ago

$loader->select_command = "SELECT * FROM ( SELECT news_id, url, keywords, keywords_hash, COUNT(*) AS count FROM {$site[$sid][dbprefix]}_seo_referer AS t1 WHERE date >= '{$date}' GROUP BY keywords_hash ) AS t2 WHERE count >= {$site[$sid][chastota]}";

Here in the request, if you try to search by field "count" from phpgrid, an error occurs sql query.

0 Vote Up Vote Down

Felix Lugaru answered 12 years ago

Maybe I have an old version phpgrid? My version phpgrid-full-v1.4.8.2
If so, where to get the update?

0 Vote Up Vote Down

Felix Lugaru answered 12 years ago

Everything would be easier if it were possible to be to each field in phpgrid assigned its own alternative sql query.
I look forward to your comments.

0 Vote Up Vote Down

Abu Ghufran answered 12 years ago

Working demo emailed to you.
Regards,

0 Vote Up Vote Down