[RESOLVED] How Can we use more than one Data Base Access in One Page

binumathew

How Can we use more than one Data Base Access in One Page
Can u show me some Code Snippets???😕

iTMarkerZ Technologies

scrupul0us

can you show us how you are using ONE so we can make recommendations

binumathew

Sir,
what i mean is i want to get details from two tables which is in one database.is it possible say hw??

scrupul0us

yes its possible but it all depends on what you want... you may need a form of join or a simple query... need more info

binumathew

with one connection,with 2 query

scrupul0us

what i meant by more information is:

what tables are you trying to access?
what data from the tables are your trying to return?
what if any relationships exists between the two tables for the returned data?

are you simply looking to pull apples and oranges with them having nothing in common? if so you'll just have to code another $sql query and resultant resource and work from there

type out what you want..

"i want all the details from the cars table and the latest record from the warranty table"

if those have no relation then you need two queries

now if you want all the details from the cars table relating to the latest warranty then that's a inner join query and can be done together

binumathew

scrupul0us;10905929 wrote:
what i meant by more information is:

what tables are you trying to access?
what data from the tables are your trying to return?
what if any relationships exists between the two tables for the returned data?

are you simply looking to pull apples and oranges with them having nothing in common? if so you'll just have to code another $sql query and resultant resource and work from there

type out what you want..

"i want all the details from the cars table and the latest record from the warranty table"

if those have no relation then you need two queries

now if you want all the details from the cars table relating to the latest warranty then that's a inner join query and can be done together

thks for ur replay sir......sir its twodifferent tables with no relations

scrupul0us

then you need two different queries:

$q1 = 'select * from table_1';
$q2 = 'select * from table_2';

$r1 = mysql_query($q1);
$r2 = mysql_query($q2);

then you have to parse the two recordsets to get your data out

if you need to use them together during out i think you can do


while($row1 = mysql_fetch_assoc($r1) and $row2 = mysql_fetch_assoc($r2))
{
//output
}

not entirely sure on that tho