From owner-freebsd-questions@FreeBSD.ORG  Sun Mar 23 23:04:03 2008
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 890A3106566B
	for <freebsd-questions@freebsd.org>;
	Sun, 23 Mar 2008 23:04:03 +0000 (UTC)
	(envelope-from rock_on_the_web@comcen.com.au)
Received: from angel.comcen.com.au (angel.comcen.com.au [203.23.236.69])
	by mx1.freebsd.org (Postfix) with ESMTP id 219DB8FC22
	for <freebsd-questions@freebsd.org>;
	Sun, 23 Mar 2008 23:04:02 +0000 (UTC)
	(envelope-from rock_on_the_web@comcen.com.au)
Received: from [192.168.0.199] (202-172-126-254.cpe.qld-1.comcen.com.au
	[202.172.126.254])
	by angel.comcen.com.au (8.13.4/8.12.9) with ESMTP id m2NN3fsG088353
	for <freebsd-questions@freebsd.org>;
	Mon, 24 Mar 2008 10:03:42 +1100 (EST)
From: Da Rock <rock_on_the_web@comcen.com.au>
To: freebsd-questions@freebsd.org
Content-Type: text/plain
Date: Mon, 24 Mar 2008 09:03:35 +1000
Message-Id: <1206313415.6973.78.camel@laptop2.herveybayaustralia.com.au>
Mime-Version: 1.0
X-Mailer: Evolution 2.12.3 (2.12.3-3.fc8) 
Content-Transfer-Encoding: 7bit
X-comcen-MailScanner-Information: Please contact the ISP for more information
X-comcen-MailScanner: Found to be clean
X-comcen-MailScanner-SpamCheck: not spam, SpamAssassin (not cached,
	score=-16.439, required 4, autolearn=not spam, ALL_TRUSTED -1.80,
	AWL 0.36, BAYES_00 -15.00)
X-comcen-MailScanner-From: rock_on_the_web@comcen.com.au
Subject: OT: (Way OT) PHP and MySQL concurrency control using MyISAM tables
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sun, 23 Mar 2008 23:04:03 -0000

I know this is not quite the list for these things, but I tried the PHP
list and got no reply whatsoever. In fact, I don't think anyone's home
cause the entire list is silent...

I'm trying to setup a system using web apps in PHP using MySQL as the
backend database, only this time I need transaction services. According
to the PHP manual if a transaction is served for MySQL it can come back
as committed even though it may not. So what I'm trying to accomplish is
develop some row level locking with the PHP script.

I enquired about setting up a servlet (for want of a better term) with
PHP, something that will serve the requests of the rest of the app. To
be honest though, I'm not entirely sure how to approach this.

Any ideas would be very welcome.

Cheers