Mysidia Adoptables Support Forum  

Home Community Mys-Script Creative Off-Topic
Go Back   Mysidia Adoptables Support Forum > Mysidia Adoptables > Questions and Supports

Notices

Reply
 
Thread Tools Display Modes
  #1  
Old 03-24-2017, 10:41 AM
ewe ewe is offline
Member
 
Join Date: Mar 2017
Posts: 8
Gender: Female
Credits: 1,739
ewe is on a distinguished road
Default Outer Join in 1.3.4?

I see that _select_query in the Database class does an inner join and some queries listed here on the forums have left joins but they also call a function which I did not see in the 1.3.4 functions.

I need to keep the null values in the column that is the join condition. So what's the best way to accomplish a left outer join?

Last edited by ewe; 03-24-2017 at 10:44 AM.
Reply With Quote
  #2  
Old 03-25-2017, 07:04 PM
Hall of Famer's Avatar
Hall of Famer Hall of Famer is offline
Administrator, Lead Coder
 
Join Date: Dec 2008
Location: South Brunswick
Posts: 4,448
Gender: Male
Credits: 327,344
Hall of Famer is on a distinguished road
Default

Well if you want a custom query, since call $mysidia->db->query($query) and write the query string in $query. Mysidia's Database class extends from PDO, so this should be pretty easy to achieve.
__________________


Mysidia Adoptables, a free and ever-improving script for aspiring adoptables/pets site.
Reply With Quote
  #3  
Old 03-25-2017, 11:03 PM
ewe ewe is offline
Member
 
Join Date: Mar 2017
Posts: 8
Gender: Female
Credits: 1,739
ewe is on a distinguished road
Default

Welp I over-complicate things!
Writing a plain SQL statement without the prefix thing worked perfectly.

Thank you so much!
Reply With Quote
Reply

Tags
join, mysql

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 06:11 AM.

Currently Active Users: 448 (0 members and 448 guests)
Threads: 4,080, Posts: 32,024, Members: 2,016
Welcome to our newest members, jolob.
BETA





What's New?

What's Hot?

What's Popular?


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
vBCommerce I v2.0.0 Gold ©2010, PixelFX Studios
vBCredits I v2.0.0 Gold ©2010, PixelFX Studios
Emoticons by darkmoon3636