Trying to use the solution without positive results First need to clarify, I'm actually trying to order the model. Here's my original query;
$make_query = "SELECT make.make, model.model, application.make_id, application.model_id FROM application INNER JOIN make ON make.id = application.make_id INNER JOIN model ON model.id = application.model_id WHERE application.year_in <= $value AND application.year_out >= $value AND application.make_id != 1 ORDER BY make.make, model.model"; here's what I tried to change it too $make_query = "SELECT make.make, model.model, application.make_id, application.model_id FROM application INNER JOIN make ON make.id = application.make_id INNER JOIN model ON model.id = application.model_id WHERE application.year_in <= $value AND application.year_out >= $value AND application.make_id != 1 ORDER BY make.make, if(left(model.model,7)='No model specified','zzzzzzzz',model.model)"; I get the same results with both. If you can, let me know where I strayed. Also, out of curiosity, is it faster to do it in MySQL rather then PHP? Thanks, Tom > From: "Mark Charette" <[EMAIL PROTECTED]> > Date: Fri, 19 Oct 2001 12:34:24 -0500 > To: "Tom Beidler" <[EMAIL PROTECTED]>, "php list" > <[EMAIL PROTECTED]> > Subject: RE: [PHP] how to move one element of an array to the end of the array > > if(left(Make,7)='no make','zzzzzzzz',Make) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]