What am I missing?

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

  I have a line of code in my PHP that should order results of a query on a
view.  Without the "ORDER BY" clause, there is nothing wrong.  With it in
the statement, incorrect results are returned from  within PHP.  I can make
the same query in MySQL and the results are correct.

             $sqlSelect = ("SELECT DISTINCT state FROM ".$view." ORDER BY
state ASC");
             $resSelect = mysqli_query($sqlConnect, $sqlSelect);
             if (!$resSelect) {
                 $response = "false";
                 echo $response;

This is the section of code to which I am referring.  Would anyone care to
venture a guess as to why this is not working in the program?


Re: What am I missing?

David Goldstein wrote:
Quoted text here. Click to load it

Did you read any of the responses here so far?

Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.

Site Timeline