WampServer

can someone help me how to display multiple records from different table in mysql??...by the way i'm using the include function in php to view a record from a different page..is there another way rather than mysql_fetch_array to get the records??..

can i do this??
sample:

$result1 = mysql_query("SELECT * FROM dbName1";
$result2 = mysql_query("SELECT * FROM dbName2";

while($row1 = mysql_fetch_array($result1))
{
//statement here
}

while($row2 = mysql_fetch_array($result2))
{
//statement here
}

Hi,

If you want to display multiple rows from different tables, usually the tables are related by key fields and you can use the JOIN statement, see examples in the MySQL Reference Manual at [dev.mysql.com].

The include() function in PHP does not access your database but includes and evaluates a file containing PHP source code.

Other mysql_ or mysqli_ commands are mysql_fetch_row and mysql_fetch_object.

And your code looks all right.

Regards,

toivo
Sydney, Australia

thanks for the reply toivo...i'll try this one.