Select from multiple tables

Kranthi Krishna <[email protected]> Wed, 29 Feb 2012 19:31:54 +0530

Newsgroups	gmane.comp.php.database
Message-ID	<CAJAheL4Rtu2E0y=4-zgHvUiOztmvkHPaZqaihBT=uHvh+6+9Wg@mail.gmail.com>

Hi all,

Say I have an object like

array
    schoolName => string
    board => array
         string
         string

I generally create  two MySql tables

schools: id PRIMARY KEY, SchoolName
boards: id FOREGIN KEY refers Table A(id), board

and then do two selects. The problem is that, the number of selects
increase as the number of one-to-many relationships increase.

Is there a better way to do this ? I have to extend an existing code
so I cannot use any libraries like doctrine

Kranthi.
http://goo.gl/e6t3

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php