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/
 



Reply via email to