mysql - How to fetch Distinct Title from the GROUP_CONCAT as Left Join without repeating other tables' data? -

-

i've got table of values this:

table:     prop_feat type       feat appliances gas range appliances fridge interior   hardwood flooring

i'm trying display type once features below:

appliances

gas range, fridge

interior

hardwood flooring

these values empty need left join table. i've searched everywhere! how should writing mysql display results this? have far isn't quite doing it. (i know.. not left join.. )

select *   (select group_concat( distinct concat ('', type, '', prop_feat.feat, '')     order type asc separator ' '  ) prop_feat prop_feat.id_prop = '$page'  )  feat properties id_pg = '$page'

any appreciated!

edit

this whole query.. i've got whole bunch of joins. making type/feature issue difficult.

select *, group_concat(concat('<tr><td>', style, '</td><td>', beds, '</td><td>', ba, '</td><td>', sq_ft, '</td><td>', rent, '</td><td>', dep, '</td></tr>')      order beds desc separator '') unit,  (select      group_concat( distinct concat ('<h4>', type, '</h4><div>', prop_feat.feat, '</div>')          order type asc separator ' '  )     prop_feat     prop_feat.id_prop = '$page'  )  interior  properties  inner join prop_units on prop_units.id_prop = '$page' left join prop_intro on prop_intro.id_prop = '$page'   left join prop_hours on prop_hours.id_prop = '$page'   id_pg = '$page' group type

properties has: name, address, city, prov, postcode, phone (display 1 property - basic info)
prop_units has: beds, bath, square feet, rent, deposit, style
prop_intro: title, text (description of place)
prop_hours: sunfrom, sunto, monfrom, monto, etc (times open during week)
prop_feat: property features has hardwood flooring, need sort type , display type once.. if possible!

edit edit - using instead

$info = mysql_fetch_array(mysql_query("select *, group_concat(concat('<tr><td>', style, '</td><td>', beds, '</td><td>', ba, '</td><td>', sq_ft, '</td><td>$', rent, '</td><td>',if(dep='','','$'), dep, '</td></tr>')      order u_order asc separator '') unit properties  inner join prop_units on prop_units.id_prop = '$page' left join prop_intro on prop_intro.id_prop = '$page'   left join prop_hours on prop_hours.id_prop = '$page'   id_pg = '$page'"));  $check = mysql_query("select type, group_concat(concat('<tr><td>', feat, '</td></tr>') separator '') featlist prop_feat id_prop = '$page' group type");

you need use group by clause because group_concat() aggregate function.

select  title, group_concat(feat) featlist    prop_feat group   title

output

╔════════════╦═══════════════════╗ ║   title    ║     featlist      ║ ╠════════════╬═══════════════════╣ ║ appliances ║ gas range,fridge  ║ ║ interior   ║ hardwood flooring ║ ╚════════════╩═══════════════════╝

Comments

Post a Comment

Popular posts from this blog

Delphi XE2 Indy10 udp client-server interchange using SendBuffer-ReceiveBuffer -

-
i use delphi xe2 , indy10 udp protocol. can't receive server echo on client side if use receivebuffer method. got "socket error # 10040" although send small echo message server client. console application illustrate problem below. in advance. program project1; {$apptype console} {$r *.res} uses system.sysutils, idglobal, idbasecomponent, idcomponent, idsockethandle, idudpclient, idudpserver, idudpbase, idstack; type tudp_serv = class(tidudpserver) procedure udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); end; var udpserver: tudp_serv; udpcl: tidudpclient; bsnd, brcv: tbytes; s: string; k: integer; //============================================================================== procedure tudp_serv.udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); begin writeln(' server read: ' + tohex(adata, length(adata))); abinding sendto(peerip, peerport, adat...
Read more

Qt ActiveX WMI QAxBase::dynamicCallHelper: ItemIndex(int): No such property in -

-
i new windows programming. here goes code objiwbemlocator = new qaxobject("wbemscripting.swbemlocator"); objwmiservice = objiwbemlocator->querysubobject("connectserver(qstring&,qstring&)",qstring("."),qstring("root\\cimv2")); qaxobject* returnlist = objwmiservice->querysubobject("execquery(qstring&)", qstring("select * %1").arg(domain)); qaxobject* result = returnlist->querysubobject("itemindex(int)", 0); i getting error on runtime qt activex wmi qaxbase::dynamiccallhelper: itemindex(int): no such property in but itemindex method exists msdn says the itemindex method not work collections not contain swbemobjects, such swbemmethodset, swbemnamedvalueset, swbemprivilegeset, swbempropertyset, , swbemqualifierset. what selecting ? have tried iterating on collection ? plus need minimum windows vista itemindex method. hope helps
Read more

Enable autocomplete or intellisense in Atom editor for PHP -

-
i'm first time user of atom editor php code. atom can autocomplete built-in functions of php. possible make editor autocomplete custom function written in separate file? function.php <?php function printsomething() { echo "hello world"; } index.php <?php require_once "function.php"; printsomething(); // autocompleted atom editor while typing thanks in advance. there text file in %userprofile%.atom called snippets.cson. in there can add snippet. more this: http://flight-manual.atom.io/using-atom/sections/snippets/ but need think can use later on other files well. otherwise need copy , paste.
Read more