Login

03-29-2008, 12:28 PM

[eluser]justmelat[/eluser]
SELECT
contractors.lname,
contractors.fname,
jobs.`position`,
clients.companyName,
jobs.current
FROM
jobs
Inner Join contractors ON jobs.contractor_id = contractors.id
Inner Join clients ON jobs.company_id = clients.id
WHERE
jobs.current = 'Yes'

03-29-2008, 12:55 PM

[eluser]Seppo[/eluser]
If you want to use ActiveRecord

Code:
$this->db->select('contractors.lname, contractors.fname, jobs.position, clients.companyName, jobs.current');

$this->db->from('jobs');

$this->db->join('contractors', 'jobs.contractor_id = contractors.id', 'inner');

$this->db->join('clients', 'jobs.company_id = clients.id', 'inner');

$this->db->where('jobs.current', 'Yes');

$query = $this->db->get();

03-29-2008, 12:56 PM

[eluser]mironcho[/eluser]
Try something like this:

Code:
$this->db->select('contractors.lname, contractors.fname, jobs.`position`, clients.companyName, jobs.current');

$this->db->from('jobs');

$this->db->join('contractors', 'contractors.id = jobs.contractor_id', 'inner');

$this->db->join('clients', 'clients.id = jobs.company_id', 'inner');

$this->db->where(array('jobs.current' => 'Yes'));

$query = $this->db->get();

03-29-2008, 12:57 PM

[eluser]mironcho[/eluser]
One minute late... Smile

03-29-2008, 01:13 PM

[eluser]justmelat[/eluser]
I am not getting and error on this line of my view

<?php echo $this->table->generate($query); ?>

the error is:
A PHP Error was encountered
Severity: Notice

Message: Undefined variable: query

Filename: views/jobs_view.php

Line Number: 14

03-29-2008, 01:14 PM

[eluser]Seppo[/eluser]
Well... are you passing the $query var to the view?

Code:
$this->db->select('contractors.lname, contractors.fname, jobs.position, clients.companyName, jobs.current');

$this->db->from('jobs');

$this->db->join('contractors', 'jobs.contractor_id = contractors.id', 'inner');

$this->db->join('clients', 'jobs.company_id = clients.id', 'inner');

$this->db->where('jobs.current', 'Yes');

$data['query'] = $this->db->get(); 

$this->load->view('jobs_view', $data);

03-29-2008, 05:15 PM

[eluser]justmelat[/eluser]
Yes, I am.

Here is the controller:
function jobs()
{
$data['title']="PureStaff-Jobs";
$data['heading']="View Current Jobs";
//$data['query']=$this->db->get('jobs');

$this->db->select('contractors.lname, contractors.fname, jobs.`position`, clients.companyName, jobs.current');
$this->db->from('jobs');
$this->db->join('contractors', 'contractors.id = jobs.contractor_id', 'inner');
$this->db->join('clients', 'clients.id = jobs.company_id', 'inner');
$this->db->where(array('jobs.current' => 'Yes'));
$data['$query'] = $this->db->get();

$this->load->view('jobs_view.php', $data);
}

Here is the View:
</head>
<body>
<h2><?php echo $heading; ?></h2>
<p><?php echo anchor('purestaff/index','Back Home');?></p>
<hr>

<?php $this->table->set_heading('JobID', 'ContractorID', 'CompanyID','Position','Start Date','End Date');?>

<?php echo $this->table->generate($query); ?>
<hr>
</body>
</html>

03-29-2008, 06:33 PM

[eluser]Seppo[/eluser]

Code:
$data['$query']

should be

$data['query']

03-29-2008, 06:53 PM

[eluser]justmelat[/eluser]
WOW, i don't believe i did that. THANK YOU!!!!