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

Posted on 2009-04-29
Last Modified: 2012-05-06
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
Question by:jtran007
    LVL 21

    Expert Comment

    Debug code and print the actual query whats getting executed.
    Seems like its not getting required parameters.
    What error its giving?

    Author Comment

    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.

    Accepted Solution

    I found the error while i increment index twice . That's why I's skiiped data.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Many companies are making the switch from Microsoft to Google Apps ( Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
    This collection of functions covers all the normal rounding methods of just about any numeric value.
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    Learn how to set-up PayPal payment integration in your Wufoo form. Allow your users to remit payment through PayPal upon completion of your online form. This is helpful for collecting membership payments, customer payments, donations, and more.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now