Ad:

MySQL Discussion Thread
Unsolved
Views: 526

Sep 25th, 2009

ORDER BY

Expand Post »

Hello all,

I have the following SQL statement.

MySQL Syntax (Toggle Plain Text)
SELECT a.airport_code AS AIRPORTCODE, a.airport_name AS AIRPORT, u.usr_id AS USERID, u.usr_fname AS FIRSTNAME, u.usr_lname AS LASTNAME, u.usr_email AS EMAIL,u.usr_airline AS AIRLINE, u.usr_airline_iatacode AS IATA, t.title AS TITLE
FROM users u LEFT JOIN userairportservices uas ON uas.usr_id_users = u.usr_id LEFT JOIN airport a ON a.airport_id = uas.airport_id_airport LEFT JOIN title t ON t.title_id = u.usr_title
WHERE a.airport_code= apcode
SELECT a.airport_code AS AIRPORTCODE, a.airport_name AS AIRPORT, u.usr_id AS USERID, u.usr_fname AS FIRSTNAME, u.usr_lname AS LASTNAME, u.usr_email AS EMAIL,u.usr_airline AS AIRLINE, u.usr_airline_iatacode AS IATA, t.title AS TITLE
FROM users u LEFT JOIN userairportservices uas ON uas.usr_id_users = u.usr_id LEFT JOIN airport a ON a.airport_id = uas.airport_id_airport LEFT JOIN title t ON t.title_id = u.usr_title
WHERE a.airport_code= apcode

I want to sort by a.airport_name but every time I add ORDER BY a.airport_name ASC to the end of this query, it fails to load the page. Is there an issue with adding and ORDER BY to the end of this statement or should it go somewhere else in it?

Thanks

Dave

Last edited by filch; Sep 25th, 2009 at 1:49 am.

Similar Threads

[B]What changes need to be made to the above database definition in order to solve al in Visual Basic 4 / 5 / 6
Listing Integers in Numerical Order in C
Sorting Not In Order in C
names in ascending order problem in C++
Changing Startup Programs Order in Windows NT / 2000 / XP

filch

Reputation Points: 10

Solved Threads: 1

Junior Poster

Offline

132 posts
since Nov 2008

Permalink

Sep 25th, 2009

Re: ORDER BY

Hi

What is the WHERE a.airport_code= apcode? if any alias for apcode

guru12

Reputation Points: 8

Solved Threads: 6

Light Poster

Offline

44 posts
since Jun 2009

Permalink

Sep 25th, 2009

Re: ORDER BY

try

sql Syntax (Toggle Plain Text)
SELECT a.airport_code AS airportcode, a.airport_name as airport, u.usr_id as userid, u.usr_fname as firstname, u.usr_lname as lastname, u.usr_email as email,u.usr_airline as airline, u.usr_airline_iatacode as iata, t.title as title FROM users u LEFT JOIN userairportservices uas on uas.usr_id_users = u.usr_id LEFT JOIN airport a on a.airport_id = uas.airport_id_airport LEFT JOIN title t on t.title_id = u.usr_title WHERE airportcode = '%s' ORDER BY airport asc, $apcode
SELECT a.airport_code AS airportcode, a.airport_name as airport, u.usr_id as userid, u.usr_fname as firstname, u.usr_lname as lastname, u.usr_email as email,u.usr_airline as airline, u.usr_airline_iatacode as iata, t.title as title from users u left join userairportservices uas on uas.usr_id_users = u.usr_id left join airport a on a.airport_id = uas.airport_id_airport left join title t on t.title_id = u.usr_title where airportcode = '%s' order by airport asc, $apcode

Last edited by almostbob; Sep 25th, 2009 at 9:45 am.

almostbob

Reputation Points: 562

Solved Threads: 368

Posting Maven

Offline

2,970 posts
since Jan 2009

Permalink

Sep 25th, 2009

Re: ORDER BY

Click to Expand / Collapse Quote originally posted by almostbob ...

try
sql Syntax (Toggle Plain Text)
SELECT a.airport_code AS airportcode, a.airport_name as airport, u.usr_id as userid, u.usr_fname as firstname, u.usr_lname as lastname, u.usr_email as email,u.usr_airline as airline, u.usr_airline_iatacode as iata, t.title as title FROM users u LEFT JOIN userairportservices uas on uas.usr_id_users = u.usr_id LEFT JOIN airport a on a.airport_id = uas.airport_id_airport LEFT JOIN title t on t.title_id = u.usr_title WHERE airportcode = '%s' ORDER BY airport asc, $apcode
SELECT a.airport_code AS airportcode, a.airport_name as airport, u.usr_id as userid, u.usr_fname as firstname, u.usr_lname as lastname, u.usr_email as email,u.usr_airline as airline, u.usr_airline_iatacode as iata, t.title as title from users u left join userairportservices uas on uas.usr_id_users = u.usr_id left join airport a on a.airport_id = uas.airport_id_airport left join title t on t.title_id = u.usr_title where airportcode = '%s' order by airport asc, $apcode

This has it. It is weird because this is more-or-less what I had and the page just came up blank. turns out that it has nothing to do with the query but something else on the page is cause the page not to render. ""sigh""

Thanks for your help

filch

Reputation Points: 10

Solved Threads: 1

Junior Poster

Offline

132 posts
since Nov 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: PostGreSQL: Optimizing a function with CASE syntax... Help please

Next Thread in MySQL Forum Timeline: MySQL select to return most recent record

DaniWeb Message

Cancel Changes

User Name
Password