On Fri, 19 Oct 2001 12:17:48 -0700, Tom Beidler wrote: >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.
try: ORDER BY make.make='no make specified',make.make,model.model >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) > > -- Mark, [EMAIL PROTECTED] on 10/18/2001 -- 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]
