PHP PDO left join not giving the same results as in mysql direct -


i have 2 db tables this: enter image description here

mysql server:

if execute following sql statement on mysql server directly all games usertogame entrys or null values if not existent.

select g.*, ug.id_usertogame, ug.id_user, ug.nickname, ug.server games g  left join usertogame ug  on g.id_game=ug.id_game , ug.id_user=11  order g.id_game

enter image description here

php pdo:

but if run following pdo statement in php games usertogames entry exists (without null values, in normal join). first thougt pdo doesnt support left join found many exaples wich prove does.

function getusergames($uid)     {         $stmt = self::$_db->prepare("select g.*, ug.id_usertogame, ug.id_user, ug.nickname, ug.server games g                                     left join usertogame ug                                     on g.id_game=ug.id_game , ug.id_user=:uid                                     order g.id_game");         $stmt->bindparam(":uid", $uid);         $stmt->execute();          return $stmt->fetchall(pdo::fetch_assoc);     }

-> $uid = 11

enter image description here

follownig statement logged mysql server (sql logging):

35 query    select * games g         join usertogame ug         on g.id_game=ug.id_game , ug.id_user='11'

why left join not work in pdo?


-

Comments

Post a Comment

Popular posts from this blog

c# - Binding a comma separated list to a List<int> in asp.net web api -

the default binder in web api expecst http://url.com/webapi/report/?pageids=3243&pageids=2365 to bind public ihttpactionresult report(list<int> pageids){ // exciting webapi code} i wish bind http://url.com/webapi/report/?pageids=3243,2365 as running out of space in url get . i have created class public class commaseparatedmodelbinder : system.web.http.modelbinding.imodelbinder { public bool bindmodel(httpactioncontext actioncontext, modelbindingcontext bindingcontext) { //binding in here } } and registered in webapiconfig.cs var provider = new simplemodelbinderprovider( typeof(list<int>), new commaseparatedmodelbinder()); config.services.insert(typeof(modelbinderprovider), 0, provider); i have altered method signature use model binder so public ihttpactionresult report( [modelbinder] list<int> pageids){ // exciting webapi code} however break point in binder not being ...
Read more

how to prompt save As Box in Excel Interlop c# MVC 4 -

i want export excel sheet using excel interloop... i have datatable convert excel sheet... now there way save file using save dialogue box in mvc 4 here code public string datatabletoexcel(datatable dt, string htmlheading, string key) { try { microsoft.office.interop.excel.application excel; microsoft.office.interop.excel.workbook excelworkbook; microsoft.office.interop.excel.worksheet excelsheet; microsoft.office.interop.excel.range excelcellrange; excel = new microsoft.office.interop.excel.application(); excel.visible = false; excel.displayalerts = false; excelworkbook = excel.workbooks.add(type.missing); excelsheet = (microsoft.office.interop.excel.worksheet)excelworkbook.activesheet; excelsheet.name = "sheet1"; dataset ...
Read more

xslt 1.0 - How to access or retrieve mets content of an item from another item? -

my use case have item has link in item. example, item 123456789/152 has metadata field dc.relation.hasversion=123456789/717 . within item view of 123456789/152 , how can retrieve values of metadata of 123456789/717 ? example, want retrieve dc.language.iso value of 123456789/717 123456789/152 . i looked @ related items feature in dspace don't know how metadata displayed in related items list pulled items in list. i using dspace version 5.3 mirage 2 theme . edit based on schweerelos answer, below actual code. using custom metadata field dc.relation.languageversion . basically, want link other version instead of displaying value, display dc.language.iso of other version in item-view.xsl . i've incorporated answer of schweerelos question in code just displaying value of dc.relation.languageversion . sample values of dc.relation.languageversion 10665.1/9843 ; 10665.1/9844 ie not complete uri handle. thanks in advance! actual code <xsl:template name=...
Read more