Is there any obvious reason why you're not doing this in one query
$query = "UPDATE media SET A='$A', B='$B', C='$C', G=E*'$C'";
Or have I missed something here ?
Cheers - Neil
At 10:07 24/06/2004 +0000, you wrote:
MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C459A5.F8D9AF1D" Date: Thu, 24 Jun 2004 14:44:45 +1000 Message-ID: <[EMAIL PROTECTED]> From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: Update data problem
if($update)
{
mysql_pconnect("localhost","root","password"); mysql_select_db("options");
$query = "UPDATE media SET A='$A', B='$B', C='$C'"; $result = mysql_query($query);
$query = "SELECT C, G FROM media"; $result = mysql_query($query);
$E= "$C*$G";
$query = "UPDATE media SET E='$E'"; $result = mysql_query($query);
}
======================================================== CaptionKit http://www.captionkit.com : Production tools for accessible subtitled internet media, transcripts and searchable video. Supports Real Player, Quicktime and Windows Media Player.
VideoChat with friends online, get Freshly Toasted every day at http://www.fresh-toast.net : NetMeeting solutions for a connected world.
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
