I left this message in the Dreamweaver section hoping for a response, I got zilch. I am hoping that someone with php and mysql experience will be able to help.
I have dreamweaver 6.0 with php and mysql using apache as the server. In a nut shell, I have a page which submits 2 variables and stores them in a table. As well as that the 2 variables are also used to search an additional table.
I have found that I can do either, insert a record into the first table or search the second table by changing the form properties from...

<?php echo $editFormAction; ?>
(this appears when I use the Insert Record Behaviour)

to...

datanchart.php?mylist=<?php echo $row_rs_shortname['recid']; ?>&myportion=<?php echo $row_rsweights['id']; ?>.

As much as I have tried I cannot get both to work together.

Can some one please help?

cheers

John

MySql - Apache - PHP - Dreamweaver MX