Mgiyuk

Retrieve data from Mysql database, display on a form, and allow user to update using PHP I am VERY NEW to PHP. I have a page where I want a user to be able to enter a citation and that information is then passed to a php script that queries against the database, returns the information in a form, and then allows the user to update any of the fields returned in that form. I have three problems: 1) When data returns, is only returns the first word in the field. Many of the fields contains multiple words. 2) When the users changes data in the field, the database isn't updated. 3) I don't seem to know how to get the form fields to display like I do for data entry. Here is the code that queries and returns the data for the user to review and update if necessary: <?php mysql_connect("***************", "*********", "****") or die(mysql_error()); mysql_select_db("***********") or die(mysql_error()); $searchterm= $_POST['searchterm...

sybase ase deferred update mode I could use some help regarding the optimizer choices for the below update. I expected a direct update, not a deferred update. In real live this concerns a target table containing ~5M rows being updated from a smaller table with ~200k rows. The deferred update takes quit some time, also because the target table has about 60 columns. Any suggestions explaining this behavior are very welcome, including suggestions to improve performance of this query. The smaller table can easily be modified, changes to the target table have more impact as it is part of the product datamodel. Many thanks! Elroy select @@version --Adaptive Server Enterprise/15.5/EBF 18158 SMP ESD#2/P/X64/Windows Server/asear155/2514/64-bit/OPT/Wed Aug 25 05:39:57 2010 IF OBJECT_ID('test_target') IS NOT NULL DROP TABLE test_target GO CREATE TABLE test_target ( id numeric(15,0) IDENTITY NOT NULL, col1 numeric(15,0) NOT NULL, col2 char(15...