Return to Question

Improved title, added a tag

Source Link

edit approved Jul 23, 2018 at 16:52

4.8k
4
18
48

JDatabase SQL AND How to write my MySQL query with JOIN logic using JDatabase methods?

I'm having a difficult time translating this SQL script to to JDatabase methods because I can't find the ANDAND query method.

SELECT user.firstname, user.lastname, leadership.leadname, leadership.lead_des
FROM CLUB,LEADERSHIP,USER
WHERE CLUB.CLUB_ID=11
AND LEADERSHIP.USER_ID=USER.USER_ID
AND CLUB.CLUB_ID=Leadership.CLUB_ID;SELECT user.firstname, user.lastname, leadership.leadname, leadership.lead_des
FROM CLUB,LEADERSHIP,USER
WHERE CLUB.CLUB_ID=11
AND LEADERSHIP.USER_ID=USER.USER_ID
AND CLUB.CLUB_ID=Leadership.CLUB_ID;

I was looking at the JDatabase documentation but don't see anything in there with ANDAND.

How can I write my query using Joomla's query syntax?

JDatabase SQL AND query

I'm having a difficult time translating this SQL script to to JDatabase because I can't find the AND query.

SELECT user.firstname, user.lastname, leadership.leadname, leadership.lead_des
FROM CLUB,LEADERSHIP,USER
WHERE CLUB.CLUB_ID=11
AND LEADERSHIP.USER_ID=USER.USER_ID
AND CLUB.CLUB_ID=Leadership.CLUB_ID;

I was looking at the JDatabase documentation but don't see anything in there with AND.

How to write my MySQL query with JOIN logic using JDatabase methods?

I'm having a difficult time translating this SQL script to JDatabase methods because I can't find the AND query method.

SELECT user.firstname, user.lastname, leadership.leadname, leadership.lead_des
FROM CLUB,LEADERSHIP,USER
WHERE CLUB.CLUB_ID=11
AND LEADERSHIP.USER_ID=USER.USER_ID
AND CLUB.CLUB_ID=Leadership.CLUB_ID;

I was looking at the JDatabase documentation but don't see anything in there with AND.

How can I write my query using Joomla's query syntax?

Source Link

asked May 14, 2015 at 17:59

Sosa

JDatabase SQL AND query

I'm having a difficult time translating this SQL script to to JDatabase because I can't find the AND query.

SELECT user.firstname, user.lastname, leadership.leadname, leadership.lead_des
FROM CLUB,LEADERSHIP,USER
WHERE CLUB.CLUB_ID=11
AND LEADERSHIP.USER_ID=USER.USER_ID
AND CLUB.CLUB_ID=Leadership.CLUB_ID;

I was looking at the JDatabase documentation but don't see anything in there with AND.

php jdatabase sql