Using MySQL to populate website with product data

[SquareEyes79]

Hi,

I have a product database which i want to use to quiclly populate parts of my website with the same info e.g. product A 'name' and 'price' in three different locations.

I have set up a IIS7, PHP and MySQL environment. In a new php file I can successfully connect to my database tables in Dreamweaver CS4, using the 'Database' tab.

When I right click and 'View Data' - no probs

When I add a Recordset, for e.g. with no filters to show all my data, and i click 'Test' all my data appears.

However, when I click 'OK' and go back to Dreamweaver nothing appears in Design View or Live View except a little php icon.

If I select Dynamic table, using the recordset, the colun headings appear but no product data.

When I do a test php echo statement the text appears, so why does the data not appear?

Thanks in advance for any help. Pls keep advice as simple aas possible!

[DwFAQ]

Heya,

If you want to view dynamic data in design view of Dreamweaver instead of the little php icon you have to enable Live View. Click on the lightning bolt icon in the toolbar between code/split/design view buttons and the Title text field or press Shift/Command/R to enable Live Data View.

[SquareEyes79]

Thanks for the quick response.

I have checked wat you said and noted that the PHP icon appears in Design View, but when I click Live View nothing appears (not even the icon).

I added a 'Hello World' text in the same file to test PHP and it does display in Live View.

Any more advice?

[SquareEyes79]

Update.

OK. I can get the data from my database to show up in Live Data vew, but I can only seem to select data down to column level.

I can create Recordset - SELECT RowA FROM table WHERE columnA = columname

I tried Recordset - SELECT RowA FROM table WHERE columnA = 1; but this is when no data displays on screen.

I need to select an individual cell value from my database table to display within my webpage. I know this is possible by writing the PHP scipt outside of Dreamweaver (but I'm only a beginner!) Is it possible using the Advanced Recordset menu interface in Dreamweaver?

Thanks

[SquareEyes79]

Update to update!

I don't know why but today my single data cell bindings I drag into Design View are displaying in Live View and Live Data View!

Hoorah.

Wish I knew why though!