James - See below :-
On 10/4/06, Gordon Stewart <[EMAIL PROTECTED]> wrote:
> ("UPDATE Yahoogroup SET `Status`='2', `date`='12 Apr 2006 15:25:03',
> `email`='[EMAIL PROTECTED]', `subject`='Re: [Groupname]
> Rail Use Surges', `modemail`='',
> `webread`='0', `IP`='123.4.56.789' WHERE (`month`='200604' and
> `group`='group' and `file`='1')")
>
>
>
> Hi, (Ive changed the email / name of the Yahoogroup). but I'm updating
> a MYSQL database, & get an error with the MYSQL query..
>
> Is there any website tutorial withmultiple field names to update with
> multiple fields at the same time - with multiple WHERE clauses ?
>
> (I can only find tutorials on single items one at a time...)
>
> Any advise on where my mistake can be - Thank you.
As per James :-
>
The actual error message from mysql_error() and the table structure (describe
Yahoogroup) would be essential to solve your problem.
<
Here it is :-
Yahoogroup
Field Type Null Default
Status tinyint(1) No 0
group varchar(22) No
month int(6) No 0
file int(4) No 0
date int(14) No 0
email varchar(25) No
modemail varchar(25) No
Subject varchar(25) No
webread char(1) No
IP varchar(15) No
Indexes:
Keyname Type Cardinality Field
group INDEX None group
Space usage:
Type Usage
Data 587,176 Bytes
Index 191,488 Bytes
Total 778,664 Bytes
Row Statistics:
Statements Value
Format dynamic
Rows 19,178
Row length ø 30
Row size ø 41 Bytes
Creation Sep 23, 2006 at 09:38 AM
Last update Oct 03, 2006 at 06:26 AM
--
G
NZ community groups - [EMAIL PROTECTED]
NZ-Website space offered.
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/php-list/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/