--- 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/