off (only 10
minutes to go), so I wasn't really thinking when I typed it.
Honestly, a unique index may be the best bet...
-Original Message-
From: Enda [mailto:[EMAIL PROTECTED]
Sent: 19 December 2003 17:13
To: Php-General
Subject: Re: [PHP] mysql update query
I used single.
bit!
unless of course someone can come in with a last minute flash of
inspiration!
i really really don't need this at 5:12 on a friday afternoon!
-Original Message-
From: Jonathan Wilkes [mailto:[EMAIL PROTECTED]
Sent: 19 December 2003 17:00
To: Enda
Subject: RE: [PHP] mysql upd
Jonathan Wilkes [mailto:[EMAIL PROTECTED]
Sent: 19 December 2003 16:39
To: Enda; Php-General
Subject: RE: [PHP] mysql update query
Hi Enda,
Does your table have an index per record ?
If so, your WHERE clause could just use the index and thus be far simpler,
if "A_Number" is an indexed fiel
Hello Enda,
Friday, December 19, 2003, 4:32:44 PM, you wrote:
E> which returns the following SQL query:
E> UPDATE cdr200311 SET Price=0.225 WHERE (A_Number = 61210146 AND
E> StartDateTime = 2003110216502400 AND Duration=15.0167 AND SMSDestinationName
E> = '1010')
E> The query executes successful
ERE
Darka
www.xfcpro.com
-Original Message-
From: Enda [mailto:[EMAIL PROTECTED]
Sent: 19 December 2003 16:33
To: Php-General
Subject: [PHP] mysql update query
Hi guys
Bit of a problem I'm having here with an update query on a PHP/MySQL site:
This is the db query I execute:
$resu
Hi guys
Bit of a problem I'm having here with an update query on a PHP/MySQL site:
This is the db query I execute:
$result6=mysql_query("UPDATE $WorkTable SET Price=$CallCost WHERE (A_Number
= $A_Number AND StartDateTime = $D_Full AND Duration=$Duration AND
SMSDestinationName = '$SMSDestinationNa
TECTED]]
Sent: December 5, 2001 11:37 AM
To: 'Tyler Longren'; Greg Sidelinger; [EMAIL PROTECTED]
Subject: RE: [PHP] mysql update query
are any of the fields of type number/integer/etc? if so, try removing the
quotes for that field.
-Original Message-
From: Tyler Longren [mail
id='$id'");
>
>Although I doubt MySQL cares if certain words are capitalized.
>
>Good luck though,
>Tyler Longren
>
>----- Original Message -----
>From: "Greg Sidelinger" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Tuesday, Decembe
are any of the fields of type number/integer/etc? if so, try removing the
quotes for that field.
-Original Message-
From: Tyler Longren [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 05, 2001 2:36 PM
To: Greg Sidelinger; [EMAIL PROTECTED]
Subject: Re: [PHP] mysql update query
On Wed, 5 Dec 2001 13:57, Greg Sidelinger wrote:
> I'm having trouble getting an update query to work
>
> Here is what I'm doing
>
> $result = mysql_query("update table set value1='$value1',
> value2='$value2' where id='$id'");
>
> It is not updating the database. All the $vars have values and I
ge -
From: "Greg Sidelinger" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, December 04, 2001 9:27 PM
Subject: [PHP] mysql update query
> I'm having trouble getting an update query to work
>
> Here is what I'm doing
>
> $result = mysql_query
I'm having trouble getting an update query to work
Here is what I'm doing
$result = mysql_query("update table set value1='$value1',
value2='$value2' where id='$id'");
It is not updating the database. All the $vars have values and I'm
using the correct columns names. Could someone please po
12 matches
Mail list logo
