Thanks!
-W
"M" <[EMAIL PROTECTED]> kirjoitti
viestissä:[EMAIL PROTECTED]
> It seems the upgrade was from Mysql 4.0. PASSWORD() function changed
> between 4.0 and 4.1, it uses longer hashes now. You can still use
> OLD_PASSWORD() function instead.
>
> William Stokes wrote:
>> Hello,
>>
>> My IS
It seems the upgrade was from Mysql 4.0. PASSWORD() function changed
between 4.0 and 4.1, it uses longer hashes now. You can still use
OLD_PASSWORD() function instead.
William Stokes wrote:
Hello,
My ISP updated their MySQL DB to 5.0.18 and that killed my login procedure
which was OK yesterd
I am prepared to be wrong (but I'm too lazy to go and try it)...
does MySql return a detailed enough error message to detect *which* field
caused the problem. IIRC, I don't think it does.
Anyway *if* it does it will be in here...
http://www.mysql.com/doc/en/Error-returns.html
DUP UNIQUE I guess
[snip]
How can I improve on the above to give specific error information.
[/snip]
Use mysql_error() http://www.php.net/mysql_error
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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
hmmm can you check to see if your field is exactly named desc in the
table... also whether or not it can accept string ie char or varchar.
- Original Message -
From: "Steven Efurd" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 25, 2003 2:03 PM
Subject: [PHP] mysql update
;jesse" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, January 05, 2003 11:50 AM
Subject: Re: [PHP] Mysql update problems
No, the query is working fine... all variables are printing correctly.
This is what has me confused. Everything seems to be as it should, it's
ju
No, the query is working fine... all variables are printing correctly.
This is what has me confused. Everything seems to be as it should, it's
just not updating the db table.
Rick Emery wrote:
what appeared when you printed the text of your query:
$query = "update bloggers set cache='$blog', t
On Monday 06 January 2003 00:27, Jesse Lawrence wrote:
> I've been scratching my head over the following code
> for a while now. It's supposed to check a given
> weblog for specific tags, and if they're present,
> update the weblog's table in my database. I believe
> the problem is around the exe
what appeared when you printed the text of your query:
$query = "update bloggers set cache='$blog', title='$title' where url='$address'";
print $query;
I'm thinking that your single quotes preventd $blog, $title, $address form being
expanded.
- Original Message -
From: "Jesse Lawrence"
On Friday, April 5, 2002, at 01:58 PM, Phil Schwarzmann wrote:
> Is this query legal?
>
> $query = "UPDATE table SET (var1, var2, var3) VALUES ($var1, $var2,
> $var3) WHERE username='$username'";
No. The SET modifier (or whatever that is) can only be used to create
column name/value rela
what happened when you tried your query?
-Original Message-
From: Phil Schwarzmann [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 12:58 PM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL - UPDATE & INSERT
Is this query legal?
$query = "UPDATE table SET (var1, var2, var3) VALUE
The UPDATE syntax in the manual:
http://www.mysql.com/doc/U/P/UPDATE.html
UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1, [col_name2=expr2, ...]
[WHERE where_definition]
[LIMIT #]
Yes, it is different than the INSERT syntax.
PS> ...but only there are like 150 diffe
On Wed, 20 Mar 2002, ROBERT MCPEAK wrote:
> $sql = "UPDATE mytable SET
> img_url=$img_url,visitdate=$visitdate,img_group=$img_group,display=$display,
> caption=$caption where id = $id";
You need to surround non-numeric values with 'single quotes'.
$sql = "update mytable s
if ($postaction=="edit")
-Original Message-
From: ROBERT MCPEAK [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 11:44 AM
To: [EMAIL PROTECTED]
Subject: [PHP] mysql update help needed
Can somebody straighten this out for me?
I can't get the update to work. I'm sure the varia
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
At 21:40 10/5/2001 -0400, [EMAIL PROTECTED] wrote:
>why isnt this working
>
>i need to get 5 values updated in a table called 'user_polls'
>
>how do I do this?
>i have
>
>UPDATE user_polls WHERE id = '$id' VALUES($1, $2. and so on
your statement is incorrect... the correct UPDATE syntax is:
Reading the MySQL manual on the UPDATE statement (my, what a concept -
actually looking at a manual, especially when you have no clue ...) would
show you that your statement is invalid and why. Something about using a
"set column-name=data" rather than an invalid "values()" statement.
Mark C.
---
UPDATE user_polls SET value='$value',value1='$value1',etc for more values WHERE id=$id
Peter Houchin
[EMAIL PROTECTED]
=
_ __ /\
/_/_/_\/ |_/ \
/_/_/_
27 matches
Mail list logo
