Welcome Guest, Not a member yet? Register   Sign In
MySQL question: 2 queries in 1
#2

[eluser]Alex007[/eluser]
Code:
$this->db->select('tbl_user.userid');
$this->db->select('tbl_user.username');
$this->db->select('tbl_user_hobbies.hobby');
$this->db->from('tbl_user');
$this->db->join('tbl_user_hobbies', 'tbl_user.userid = tbl_user_hobbies.userid', 'LEFT');


Messages In This Thread
MySQL question: 2 queries in 1 - by El Forum - 11-05-2007, 10:52 AM
MySQL question: 2 queries in 1 - by El Forum - 11-05-2007, 10:57 AM
MySQL question: 2 queries in 1 - by El Forum - 11-05-2007, 10:58 AM
MySQL question: 2 queries in 1 - by El Forum - 11-05-2007, 11:12 AM
MySQL question: 2 queries in 1 - by El Forum - 11-05-2007, 12:08 PM
MySQL question: 2 queries in 1 - by El Forum - 11-05-2007, 12:23 PM
MySQL question: 2 queries in 1 - by El Forum - 11-05-2007, 02:12 PM
MySQL question: 2 queries in 1 - by El Forum - 11-05-2007, 03:12 PM
MySQL question: 2 queries in 1 - by El Forum - 11-05-2007, 03:22 PM



Theme © iAndrew 2016 - Forum software by © MyBB