Thanks Gareth, Please see if you can answer my question.
Regards Deepak Bhatia On Wed, Sep 8, 2010 at 5:28 PM, DEEPAK BHATIA <[email protected]>wrote: > Hi, > > I have four databases by the name > > 1. rtdb > 2. crb > 3. pist > > The rtdb and pist has emp_table but the same is given employee_table in > crb. > > This link shows that if two tables names are same in two different > databases then the connection can be switched. > > pist1 database - databases.yml > ======================= > all: > propel: > class: sfPropelDatabase > param: > classname: PropelPDO > dsn: 'mysql:host=localhost;dbname=pist1' > username: root > password: null > encoding: utf8 > persistent: true > pooling: true > crb database - databases.yml > ====================== > all: > propel: > class: sfPropelDatabase > param: > dsn: 'mysql://root:@localhost/crb' > rtdb database - databases.yml > ====================== > all: > propel: > class: sfPropelDatabase > param: > dsn: 'mysql://root:@localhost/rtdb' > ====================== > > Combined databases.yml > =================== > all: > propel: > class: sfPropelDatabase > param: > classname: PropelPDO > dsn: 'mysql:host=localhost;dbname=pist1' > username: root > password: null > encoding: utf8 > persistent: true > pooling: true > > propel: > class: sfPropelDatabase > param: > dsn: 'mysql://root:@localhost/crb' > > propel: > class: sfPropelDatabase > param: > dsn: 'mysql://root:@localhost/rtdb' > > Regards > > Deepak Bhatia > On Wed, Sep 8, 2010 at 4:53 PM, Gareth McCumskey > <[email protected]>wrote: > >> Why do things outside of symfony and the databases.yml? >> >> >> http://www.lampjunkie.com/2008/04/using-multiple-databases-in-symfony-with-propel/ >> >> On Tue, Sep 7, 2010 at 7:52 AM, DEEPAK BHATIA >> <[email protected]>wrote: >> >>> Hi, >>> >>> I tried accessing some other database than specified in databases.yml. >>> But below is not working. Please help. >>> >>> $con=mysql_connect("localhost","root",""); >>> if(!$con) >>> { >>> echo "Database Connection Not Estabilished\n"; >>> exit(0); >>> } >>> $temp = mysql_select_db("rtdb"); >>> if($temp == false) >>> { >>> exit(0); >>> } >>> $query = "SELECT id FROM severity_table"; >>> $result = mysql_query($query); >>> while ($row = mysql_fetch_array($result)) >>> { >>> echo $row["id"]; echo "<BR>"; echo "HELLO"; >>> } >>> >>> >>> -- >>> If you want to report a vulnerability issue on symfony, please send it to >>> security at symfony-project.com >>> >>> You received this message because you are subscribed to the Google >>> Groups "symfony users" group. >>> To post to this group, send email to [email protected] >>> To unsubscribe from this group, send email to >>> [email protected]<symfony-users%[email protected]> >>> For more options, visit this group at >>> http://groups.google.com/group/symfony-users?hl=en >>> >> >> >> >> -- >> Gareth McCumskey >> http://garethmccumskey.blogspot.com >> twitter: @garethmcc >> >> -- >> If you want to report a vulnerability issue on symfony, please send it >> to security at symfony-project.com >> >> You received this message because you are subscribed to the Google >> Groups "symfony users" group. >> To post to this group, send email to [email protected] >> To unsubscribe from this group, send email to >> [email protected]<symfony-users%[email protected]> >> For more options, visit this group at >> http://groups.google.com/group/symfony-users?hl=en >> > > -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en
