> I am setting up a web page system which involves html pages, php pages
> and mysqldatabase.
> I have a number of questions and do not know where to find answers.
> If  I display the rows from a database table in a php generated html
> table is it possible to mark a row so that it can be deleted or
> modified by calling another php page?

I dont know if mysql supports select for update, but the locking will not
work. The reasons are:
   As soon the PHP page ends, PHP will realease all non persistent
   database connections.You can work around this, using a persistent connection( this 
type of
connection doesnt close even after the php script ends ), but this kind of
connection can bring you troubles. You will get troubles if you run insert
or update commands, because all script instances will share the same
database connection. If for some reason, a script( or the db server )
locks the table for some reason, all scripts that use the persistent connection
  will wait for the unlock of the table.Worse, if you rollback a transaction, every 
transactions that use the
persistent connection will be roolbacked.

Is there any reason to lock the rows?

>If so is this documented
> anywhere?

> Is there any good source of information on setting up 'forms'to work
> like Oracle forms where database records can be inserted, updated or
> deleted?

I dont know. Sorry.


PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to