mysql "select abc from mytable where item=abc order by sale desc limit 3

In the command line, I test this sql statement it is working.
but the same statement, somehow in my C# web page it is
not working.
I attache here my code
Who is Participating?
jtran007Connect With a Mentor Author Commented:
I found the error while i increment index twice . That's why I's skiiped data.
theGhost_k8Database ConsultantCommented:
Debug code and print the actual query whats getting executed.
Seems like its not getting required parameters.
What error its giving?
jtran007Author Commented:
I debug and check the statement .it's ok even I try on command line. its' working.
There is no error , but the query gives me more than 4 values (...limit 4) I expected.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.