CODEWITHSUNDEEP
phpmysqlsqlcodeigniter
David Ninan
David Ninan

Reputation: 47

Convert codeigniter query to sql query

i am little confused in wririting SQL query for joining muthiple tables. I have perfectly write that query in codeigniter as folows

$this->db->select('*');
$this->db->from('subscription_payment'); 
$this->db->join('user', 'user.user_id = subscription_payment.user_id');
$this->db->join('subscription', 'subscription.subscription_id = 
subscription_payment.subscription_id');
$this->db->where('subscription_payment.subscription_payment_id',$sid);
$query = $this->db->get(); 
$result= $query->result_array();

Help me to convert this to SQL query

Upvotes: 0

Views: 1171

Answers (3)

Huy Trịnh
Huy Trịnh

Reputation: 753

Using

echo $this->db->last_query();

will produce

select * from some_table...

And this is it. Next time you can convert any query you want with easy.

Upvotes: 3

zealous
zealous

Reputation: 7503

select *
from subscription_payment 
join user
on user.user_id = subscription_payment.user_id
join subscription
on subscription.subscription_id =  subscription_payment.subscription_id
where subscription_payment.subscription_payment_id = $sid

Upvotes: 2

Akina
Akina

Reputation: 42622

SELECT *
FROM subscription_payment
JOIN user ON user.user_id = subscription_payment.user_id
JOIN subscription ON subscription.subscription_id = subscription_payment.subscription_id
WHERE subscription_payment.subscription_payment_id = $sid 
;

Upvotes: 1

Related Questions