From: Alex C. <co...@pr...> - 2009-10-10 01:00:12
|
Whoops, sorry: You'd want to have one method to get all of your accounts: public function GetAccounts() { $q = $this->escape ("SELECT * FROM accounts"); // maybe add some other conditions... return $this->DB->_query ($q); } public function GetContactsForAccount ($AccountID) { $q = $this->escape ("SELECT * FROM contacts WHERE account_id = %d", $AccountID ); return $this->DB->_query ($q); } In Flash/Flex you'd call GetAccounts to load your first DataGrid/List, then when the user clicks a certain row, you'd call GetContactsForAccount, passing the id/row they clicked on... You might want to check out the tutorials on the site. They are dated, because they're from amfphp 1.2, but they still give you a good idea of how amfphp works. Alex On Fri, Oct 9, 2009 at 7:47 PM, Alex Cook <co...@pr...>wrote: > You'd want to have one method to get all of your accounts: > > public function GetAccounts() > { > > $ > > On Fri, Oct 9, 2009 at 7:36 PM, compix <rod...@gm...> wrote: > >> Hello alls... I have a database that have many tables, I need to know how >> to handle this situation: One table ( accounts ) have the fileds >> id,account,name, etc... , other table (contacts) have the fileds id, name, >> address, etc... and the other table ( account_contacts) that managed the >> relations between accounts and contacts table have the fileds id, >> account_id, contact_id, etc. I need to show in a flash datagrid the >> accounts, and when I select an account in another datagrid display the >> contacts for this account, and when I select a contact in a datagrid the >> action display the details for this contact in some editable text fields to >> modify some of this fileds... It's possible to do this with amfphp? Thanks >> in advance for the help. >> ------------------------------ >> View this message in context: How about one to many relations database<http://www.nabble.com/How-about-one-to-many-relations-database-tp25829409p25829409.html> >> Sent from the amfphp-general mailing list archive<http://www.nabble.com/amfphp-general-f3528.html>at Nabble.com. >> >> >> ------------------------------------------------------------------------------ >> Come build with us! The BlackBerry(R) Developer Conference in SF, CA >> is the only developer event you need to attend this year. Jumpstart your >> developing skills, take BlackBerry mobile applications to market and stay >> ahead of the curve. Join us from November 9 - 12, 2009. Register now! >> http://p.sf.net/sfu/devconference >> _______________________________________________ >> amfphp-general mailing list >> amf...@li... >> https://lists.sourceforge.net/lists/listinfo/amfphp-general >> >> > |