What am I missing?

[David Goldstein]

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;
exit;

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?

David

[Jerry Stuckle]

What do you mean by "incorrect results"? Wrong data? Bad return code?
Program blows up?

Did you try to echo $sqlSelect before the request to see if it's what
you think it is?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstu...@attglobal.net
==================

[Peter H. Coffin]

Precisely *what* incorrect results are returning? What does $view
contain? What does $mysqli->error() return?

--
_ o
|/)

[David Goldstein]

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;
exit;

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?

David

[Doug Miller]

It's impossible to venture any meaningful guesses until you tell us what
results you expect to get, and what results you actually get instead.
"Incorrect results are returned" is far too vague for any diagnosis.

[Jerry Stuckle]

Did you read any of the responses here so far?