Retrieve all tags for all results in MYSQL Query -


i working on video tagging system. know unique id each video want in search result previous query have run, want show of tags each video in search result in listing it's multiple categories , contributors displayed without having click through main page.

the code below returns 5 rows 2 videos in search results. can loop around result, means can't use limit functions , have build php me.

select * tags join siteupdates on tags.item_id = siteupdates.clip_id join updatetype on siteupdates.updatetype = updatetype.id_type join tagnames on tags.tag = tagnames.tagid tags.item_id in (248,257) order siteupdates.clip_date desc

result (this example of first 5 results, , have cut out of columns aren't relevant)

 uid / item_id / tag / updatetype / tagname / tagtype 1560 / 248 / 14 / 1 / tag 14 / category 1561 / 248 / 3 / 1 / tag 3 / contributor 1562 / 248 / 7 / 1 / tag 7 / category 543 / 257 / 43 / 1 / tag 43 / category 544 / 257 / 3 / 1 / tag 3 / contributor

ideally need 2 row result, containing of tag data.

alternatively, asking isn't possible just mysql , original plan loop around in php option? new query tag info each result not sound idea me possible have 50 results per page, 52 queries in total (including 1 earlier in script)!

any appreciated.

so if right want of tags, not 1 tag per result record in one? in case group_concat() might help.


Comments

Post a Comment

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

url - Querystring manipulation of email Address in PHP -

i using third party application (email2http) send me emailid, body , message. unable retrieve email id due name appended on , enclosed < , >. here querystring getting. test.php?from=ajay+reddy &subject=cx&body=somebody when print variable in php returns name , not email id. $from = $_get['from']; echo $from; //output ajay reddy please suggest me how can emailid also. i dont want use post method due testing , debugging. it's working fine. forgot use htmlentities() in debugging.
Read more