Sorry about the cross-posting. I've been a Filemaker user for around 10 years now. Its brilliant for small scale applications, but over recent months, I've been porting a site based on Filemaker v5 to PHP/MySQL. I am using PEARD:DB and the Smarty templating engine. One of the nice tricks in FM is the ability to select a field and have the value of that field set in the current found set. By using a little bit of javascript in the form, I am able to capture the filed in focus, and have built a function that will form the SQL query so that it takes account of the column type being selected. This morning, I have extended this by making it work on a multi-row table. So I can be working on a 75-row table and I can now update one of the columns to store the data that I have selected in one of the rows (obviously in the same column). If anyone would like more info (and code snippets) please let me know off list. Cheers George in Oxford -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
