Dreamweaver and mysql

[joinx]

I am doing an ecommerce website using dreamweaver cs3.

Can i create 2 recordsets for 1 page..

i want to display data from 2 different tables...

 

I have one more problem. I'm not able to retrieve the data from the database..

I am using

while ($row = mysql_fetch_array(name of recordset))

{//what i want to display}