View Single Post
  #9 (permalink)  
Old 05-23-2008, 01:59 PM
aniltc aniltc is offline
Junior Member
 
Join Date: May 2008
Posts: 9
Default

that means no need to write joins in the model.This will be equallent to join.
is it?
suppose if i want some columns from a relation table,how can i take


can i use like this in my model


<?php
$table = new Bugs();

$select = $table->select();
$select->where('bug_status = ?', 'NEW')
->join('accounts', 'accounts.account_name = bugs.reported_by')
->where('accounts.account_name = ?', 'Bob');

$rows = $table->fetchAll($select);

?>

PHP Interview Questions AJAX Interview Questions MySQL Interview Questions PHP web Development questions PHP FAQs Tutoring Online PHP PHP Programming Questions PHP Freshers Job Questions Testing Interview Questions PHP OOPs interview questions *Techn
Thanks

Last edited by aniltc : 05-27-2008 at 04:13 AM.
Reply With Quote