Re: Subject: Update data problem

["Neil Smith [MVP, Digital media]" <php@xxxxxxxxxxxxxxxxxxxxxxxx>]

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: <39B7E7009F2DD840AA747934AB551E6917169B@xxxxxxxxxxxxxxxxxxxxxxx>
> From: <Justin.Baiocchi@xxxxxxxx>
> To: <php-db@xxxxxxxxxxxxx>
> 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