Select from multiple tables
| From: | Kranthi Krishna | Date: | Wed, 29 Feb 2012 14:01:54 +0000 |
| Subject: | Select from multiple tables | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-48205@lists.php.net to get a copy of this message | ||
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