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
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 field, then
UPDATE cdr200311 SET Price=0.225 WHERE A_Number = 61210146
Alternatively, try removing the () around the WHERE
Darka
www.xfc
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
What error are you getting, exactly?
MySQL is not case-sensitive with regards to commands, but it is
case-sensitive for table names, column names, etc. Make sure that the
table names are exactly exact ;-) including cases, etc.
You might double-check the values in the variables: do they contai
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
Everything looks good to me...try this:
$result = mysql_query("UPDATE table SET value1='$value1',value2='$value2'
WHERE id='$id'");
Although I doubt MySQL cares if certain words are capitalized.
Good luck though,
Tyler Longren
- Original Message -
From: "Greg Sidelinger" <[EMAIL PROTECT
10 matches
Mail list logo
