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? I have to admit I have been stuck on this for a couple of days.

cheers

John

MySql - Apache - PHP - Dreamweaver MX

Edited by - johnhendy on 19 Mar 2004 15:02:53