php - sqs order by value asc -

-

i have mysql query in php file. want order results ascending values column in 1 of tables using 'order value asc'. however, results being produced current query not ordering value, value in table. presume because have syntax wrong cant work out how. have been trying work out few weeks no joy, can help?

thanks in advance replies.

query:

$find_query3 = mysql_query("select  patients.*,  addobs.*,  date_format(addobs.datetime, '%d/%m/%y %h:%i:%s') dti1, (select date_format(min(addobs.datetime), '%m/%d/%y %h:%i:%s') addobs addobs.mrn = patients.mrn , addobs.datetime >= lastokpar.lastdatetime , addobs.par >= $par , addobs.hidden != 'yes') dti2 addobs  inner join patients on addobs.mrn = patients.mrn left join ( select  addobs.mrn   , max(addobs.datetime) lastdatetime addobs  addobs.par < $par  , addobs.hidden != 'yes' group addobs.mrn ) lastokpar on lastokpar.mrn = addobs.mrn  addobs.datetime = (select max(olast.datetime) addobs olast olast.mrn = patients.mrn) , addobs.par >= $par  , not addobs.hidden = 'yes' , coalesce(patients.ward,'') != 'dc'     order addobs.par asc, dti2 asc

ps results ordered date of birth, 1 of columns 'patients'. dont know why has chosen order this. im sure there logic havnt worked out!

thanks,

matt

try this

order addobs.par ,  (select date_format(min(addobs.datetime), '%m/%d/%y %h:%i:%s') addobs      addobs.mrn = patients.mrn , addobs.datetime >= lastokpar.lastdatetime , addobs.par >= $par   , addobs.hidden != 'yes')

Comments

Post a Comment

Popular posts from this blog

javascript - Unusual behaviour when drawing lots of images onto a large canvas -

-
in javascript code, download bunch of links of images, , draw them canvas in grid theme. number of links there are, , set width , height of canvas accordingly, there 200 images per row. height based on total number images. problem noticing based on height use, images show on canvas. example, if set height 12 rows, see images, if set on that, no images show up. when setting in 1 row, images show in firefox 23. ie9 , chrome29 shows nothing. does know if there wrong here, or stable way drawing lots of images large canvas? thanks. function onprofilesuccessmethod(sender, args) { alert("request arrived"); var listenumerator, piccount, item, picobj, path, office, ctx, x, y, imageobj; listenumerator = listitems.getenumerator(); piccount = listitems.get_count(); var w = 125; var h = 150; var rl = 200; var canvas = document.createelement('canvas'); canvas.id = "picgallery"; canvas.width = w * rl; canvas....
Read more

how can i manage url using .htaccess in php? -

-
i want manage url of website right showing me www.computermall.co.in/product_details.php?prdid=34 but want www.computermall.co.in/product_details/34 how can it? i have tried this options +followsymlinks -multiviews rewriteengine on rewritebase /computermall # uri-path directly the_request variable rewritecond %{the_request} ^(get|head)\s/(.*)\.php [nc] # strip extension , redirect permanently rewriterule .* /%2 [r=301,l,nc] rewritecond %{request_filename} !-f rewritecond %{request_filename} !-d rewritecond %{request_uri} !\.php [nc] # map internally original resource rewriterule ^(.*)$ $1.php [l,qsa] try this: rewriteengine on rewriterule ^product_details/prdid/([^/]*)$ /product_details?prdid=$1 [l] edit: removed leading slash
Read more

javascript - Chart.js - setting tooltip z-index -

-
http://jsfiddle.net/gmannib/j2mwpj43/7/ ^ see sample fiddle above. notice how tooltips piechart go underneath "earth" icon have in middle there? there way set z-index property of tooltips above earth icon? thought work? race.tooltip.style.zindex = "5"; i'm still learning...thank kind help! just give higher z-index value canvas , done. see demo . css code canvas#race{position:relative; z-index:1;}
Read more