--- Gordon Stewart <[EMAIL PROTECTED]> wrote:

> 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              

And the error message is ...?

James



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