Where's Dreamweaver's Dynamic Table Insert Function???

[David B]

I learned how to connect Dreamweaver to a MySQL database, and now I'm
trying to figure out how to insert the database on a web page and
manipulate it. A tutorial at http://www.ucl.ac.uk/is/mysql/dreamweaver/
says the easiest way is click Insert > Dynamic Table. But I don't see
"Dynamic Table" listed anywhere. I checked Dreamweaver's Help function,
but it doesn't have much to say about dynamic tables.

Also, all the functions you do by clicking Insert, +, etc. are just
short-hand for coding, right? In other words, if I get stuck, can I just
go into code view and do it by hand?

I drug a database table and a recordset onto my page, but nothing
happened. Then I went into bindings and drug a specific field onto the
page, and the data showed up - but just one row.

I made a very simple table, with the name, abbreviation and a few other
items pertaining to just two states and two Canadian provinces. I made a
table and copied the code into two cells. So when I preview my page, I
see "Alberta" and "Edmonton."

But I can't see the next row - British Columbia. Can I simply copy the
code below and modify it to make it display the second row?

<table cellspacing="0">
<tr>
<td><?php echo $row_Recordset1['Name']; ?></td>
<td><?php echo $row_Recordset1['Capital']; ?></td>
</tr>
</table>

[Ken Ford - PVII Support]

Insert > Application Objects > Dynamic Data > Dynamic Table

The easiest way to do what you want is to use a Repeat Region.

Click on the <tr> tag in the bottom of the Design View window and then click the (+) sign in the Server Behaviors Panel and select
Repeat Region.

It should look something like this when you are done:

<table cellspacing="0">
<?php do { ?>
<tr>
<td><?php echo $row_Recordset1['Name']; ?></td>
<td><?php echo $row_Recordset1['Capital']; ?></td>
</tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>
--
Ken Ford
Certified Dreamweaver MX 2004 Developer
PVII Support Team
http://www.projectseven.com

Post by David B
I learned how to connect Dreamweaver to a MySQL database, and now I'm
trying to figure out how to insert the database on a web page and
manipulate it. A tutorial at http://www.ucl.ac.uk/is/mysql/dreamweaver/
says the easiest way is click Insert > Dynamic Table. But I don't see
"Dynamic Table" listed anywhere. I checked Dreamweaver's Help function,
but it doesn't have much to say about dynamic tables.
Also, all the functions you do by clicking Insert, +, etc. are just
short-hand for coding, right? In other words, if I get stuck, can I just
go into code view and do it by hand?
I drug a database table and a recordset onto my page, but nothing
happened. Then I went into bindings and drug a specific field onto the
page, and the data showed up - but just one row.
I made a very simple table, with the name, abbreviation and a few other
items pertaining to just two states and two Canadian provinces. I made a
table and copied the code into two cells. So when I preview my page, I
see "Alberta" and "Edmonton."
But I can't see the next row - British Columbia. Can I simply copy the
code below and modify it to make it display the second row?
<table cellspacing="0">
<tr>
<td><?php echo $row_Recordset1['Name']; ?></td>
<td><?php echo $row_Recordset1['Capital']; ?></td>
</tr>
</table>

[David B]

Post by Ken Ford - PVII Support
Insert > Application Objects > Dynamic Data > Dynamic Table
The easiest way to do what you want is to use a Repeat Region.
Click on the <tr> tag in the bottom of the Design View window and then click the (+) sign in the Server Behaviors Panel and select
Repeat Region.
<table cellspacing="0">
<?php do { ?>
<tr>
<td><?php echo $row_Recordset1['Name']; ?></td>
<td><?php echo $row_Recordset1['Capital']; ?></td>
</tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>

Oops, I guess I didn't look hard enough. I've been using Dreamweaver for
over a year, and I still have a lot left to explore!

Thanks for the extra tips, too. Everything just came together.