Welcome Guest, Not a member yet? Register   Sign In
multiple dropdowns
#1

[eluser]RobertB.[/eluser]
MySql
Code:
SELECT se.service_id, se.service, pr.price, s2p.description
FROM sw_service2price s2p
LEFT JOIN sw_services se ON s2p.serviceId = se.service_id
LEFT JOIN sw_service2interval s2i ON se.service_id = s2i.serviceId
LEFT JOIN sw_prices pr ON s2p.priceId = pr.price_id
WHERE s2i.intervalId =1

Result * Is correct.

ID Services Prices Desc
-------------------------------------
1 | Service 1-1 | 22.95 | desc 1-1
1 | Service 1-2 | 29.95 | desc 1-2
2 | Service 2-1 | 59.95 | desc 2-1

The Question -
How can I make both services with the ID of 1 in one dropdown and the one with the ID of 2 on a different dropdown, is this possible?

I'm trying to use ajax but I only get one dropdown with all 3 items
This is part of the code in my controller
Code:
$interval = $this->input->post('interval');
$data['services'] = $this->iSelector->getServices($interval);

$data['output'] = '';
foreach($data['services'] as $service){
$data['output'] .= '<option value="">'.$service->service.'</option>';
}

echo json_encode($data);




Theme © iAndrew 2016 - Forum software by © MyBB