select query using array

[nhojeinnor]

hi i have this function for select / function select($table, $rows = '*', $where = null, $group = null, $order = null, $limit = null)   

 

this is what i do to display the records.

 

$db->select('loan');

$records = $db->getResult();

foreach($records as $row) {

 

$user = $row['id'];

//$name = $row['firstname'];

 

//print_r($row);

echo $user;

 

?>

the codes is running.but when i want to use WHERE id = $_POST['id'];

 

this is what im doing.

 

$db->select('member')->where(array('id' => $_POST['client']));

 

an error as occured where in function where is not existing. please help how to use the proper way of using select  * $table where id=$id; in array. thanks

[nankoweap]

try this...

 

$db->select('member', '*', 'id = ' . $_POST['id']);

[nankoweap]

or rather...

 

$db->select('member', '*', array('id' => $_POST['id']));

[nhojeinnor]

can i store it using array?

 

like $data = array('id'=>$client);

 

thanks