mysql - Result set order changing in php -


i have result set , need displayed on screen.but problem while displaying each row of result set using echo command order getting changed.can why happening , provide me way overcome it.here actual , printed outputs.

actual result set: 

jaike-ilene-wacki-mazie-regle-sbj-kmmu   lvz-harty-mugzy-stw  mazie-sixie-sbj-kmmu   pxt-louie-gatby-razer-buzie-jaike-ilene-wacki-mazie   swann-gatby-razer-buzie-jaike-ilene-wacki-mazie

output: 

 jaike-sbj-ilene-kmmu-wacki-mazie-regle  mugzy-stw-lvz-harty  sbj-kmmu-mazie-sixie  ilene-gatby-wacki-razer-mazie-buzie-pxt-jaike-louie  wacki-razer-mazie-buzie-jaike-swann-ilene-gatby

here code 

$sql3="select group_concat(l.fix_ident separator '-') fix_seq,l.airport_ident,x.star_ident,x.transition_ident,                  x.fix_ident corept.std_star_leg l                  join                     (select distinct c.airport_ident,c.star_ident,c.transition_ident,c.fix_ident                      corept.std_star_leg c                      inner join                           (select star_ident,transition_ident,max(sequence_num) seq,route_type                            corept.std_star_leg                            data_supplier='j'                            , airport_ident='kmmu'                            group star_ident,                            transition_ident)b on c.sequence_num=b.seq                            , c.star_ident=b.star_ident , c.transition_ident=b.transition_ident                            left join                                (select name,trans                                 skyplan_deploy.deploy_stars                                 apt='kmmu'                                 , name!=trans) d                                 on d.name=c.star_ident                                 , d.trans=c.fix_ident                                 c.data_supplier='j'                                 , c.airport_ident='kmmu' , d.name null)x                                 l.airport_ident='kmmu' , l.transition_ident=x.transition_ident                                 , l.star_ident=x.star_ident , l.data_supplier='j'                                 group x.star_ident,x.transition_ident                                 order l.star_ident,x.transition_ident,l.sequence_num";   $res3=mysqli_query($mysqli,$sql3);   if($res3)   {     while($newarray3=mysqli_fetch_array($res3,mysqli_assoc))     {     $apt=$newarray3['airport_ident'];     $star_ident=$newarray3['star_ident'];     $trans_ident=$newarray3['transition_ident'];     $fix_ident=$newarray3['fix_ident'];     $fix_seq=$newarray3['fix_seq'];     echo $apt.",".$star_ident.",".$trans_ident.",".$fix_ident.",corept,".$fix_seq;     echo "<br>";     }   }  else  {    printf("error:%s\n",mysqli_error($mysqli));  }

your query looks overly complex. appears finding groupwise maximum std_star_leg records sequence_num (grouped on start_ident , transition_ident), excluding there matching non-self-referencing deploy_star, returning results grouped again matching fix_ident values concatenated string?

if so, following simplified query ought achieve same outcome:

select   group_concat(fix_ident separator '-') fix_seq,          airport_ident,          star_ident,          transition_ident     corept.std_star_leg l natural join (            select   star_ident, transition_ident,                     data_supplier, airport_ident,                     max(sequence_num) sequence_num                corept.std_star_leg               data_supplier = 'j'                 , airport_ident = 'kmmu'            group star_ident, transition_ident          ) b    not exists (            select null              skyplan_deploy.deploy_stars d             d.name != d.trans               , d.name  = l.star_ident               , d.trans = l.fix_ident               , d.apt   = l.airport_ident          ) group star_ident, transition_ident

note whereas selecting x.fix_ident in outermost select list, have omitted such column because value indeterminately selected server amongst in fix_seq.

now, problem (which appears related order in fix_ident values appear within group_concat() string fix_seq—although it's terribly hard appreciate question), perhaps want use order by parameter group_concat() function? example:

select group_concat(fix_ident separator '-' order ...) fix_seq

however, not clear me ordering require (the order by clause in original query entirely redundant).


Comments

Post a Comment

Popular posts from this blog

Change php variable from jquery value using ajax (same page) -

what i'm trying this: i've php global variable $currentid , simple jquery script check if there "id" (page) in hash of url , if yes wanted give value $currentid . i've been reading lot , notice shall use ajax i'm not managing it. my code is: <script type="text/javascript"> $(document).ready(function(){ if (parent.location.hash != '' ) { var thecurrentid = parent.location.hash.split('#')[1]; $.ajax({ url: 'my.php', //current page type: 'post', data: {theid: thecurrentid }, datatype: 'json', success: function () { } }); } // code here }); </script> could me please? thank in advance. php server side language, meaning once has sent data browser, php variables , data cannot changed... however, using ajax, can send request php page , change data in dom based on result. consider th...
Read more

Pull out data related to my apps from Android Play Store and iOS App Store -

i want pull out data related apps (ratings, reviews, etc) google play store , apple app store ? how can accomplish ? i have found open source apis google mentioned not reliable. also there paid apis (e.g. appfigures) available. has idea how able pull data these play stores ?? i looking direction on how can accomplish this. can suggest ? we (appfigures) have been working on developing infrastructure give ability reviews , bunch of other data points major app stores several years :] we make available via our api though may want check out.
Read more

How can I fetch data from a web server in an android application? -

i want retrieve data web server in android application, , don't know begin. should use web services? i recommend these tutorials: connect android php , mysql , json in android , php , mysqli i used these tutorials , managed trying working without difficulty. between them describe each step in how attempting @ each stage, android application, database , web server side , has information included can process , use received information the thing add connect android php , mysql tutorial makes use of mysql_ in php deprecated. better use mysqli why included third link. the basic outline of want this: 1) in android app make request server php script using class this: import java.io.bufferedreader; import java.io.ioexception; import java.io.inputstream; import java.io.inputstreamreader; import java.io.unsupportedencodingexception; import java.util.list; import org.apache.http.httpentity; import org.apache.http.httpresponse; import org.apache.http.namevaluepair...
Read more