RE: [PHP-DB] Request for help on (My)SQL Statement

place. Thanks, John -Original Message- From: Micah Stevens [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 27, 2004 6:23 PM To: Bedard, John Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Request for help on (My)SQL Statement Well then there's no reason to copy the value. Just sele

Re: [PHP-DB] Request for help on (My)SQL Statement

and isn't a total abomination... :) > > Thanks, > > John > > -Original Message----- > From: Micah Stevens [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 27, 2004 5:30 PM > To: Bedard, John > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Request for help o

Re: [PHP-DB] Request for help on (My)SQL Statement

> > John, you're getting that error message because the > max() function requires a GROUP BY clause. > Ooops, my bad. It requires a GROUP BY if you are pulling from more than one column. = ~Rachel __ Do you Yahoo!? Win a $20,0

RE: [PHP-DB] Request for help on (My)SQL Statement

t; Thanks, > > John > > -Original Message- > From: Micah Stevens [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 27, 2004 5:00 PM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Request for help on (My)SQL Statement > > > > That would be the way to

Re: [PHP-DB] Request for help on (My)SQL Statement

> UPDATE ngc_polling SET lastrundate = > max(nuke_phpbb_posts.post_time) > > It returns "Invalid use of group function." > John, you're getting that error message because the max() function requires a GROUP BY clause. Try this: SELECT max(nuke_phpbb_posts.post_time) FROM nuke_phpbb_posts

Re: [PHP-DB] Request for help on (My)SQL Statement

iginal Message- > From: Micah Stevens [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 27, 2004 5:00 PM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Request for help on (My)SQL Statement > > > > That would be the way to do it except that MySQL doesn't support > sub

RE: [PHP-DB] Request for help on (My)SQL Statement

Okay, I'll go in that direction. Thanks! John -Original Message- From: Swan, Nicole [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 27, 2004 5:17 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Request for help on (My)SQL Statement You're right, of course, Micah. I guess

RE: [PHP-DB] Request for help on (My)SQL Statement

PROTECTED] Sent: Tuesday, April 27, 2004 5:00 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Request for help on (My)SQL Statement That would be the way to do it except that MySQL doesn't support sub-selects until version 4.1, which is in alpha still. -Micah On Tuesday 27 April 2004 04:05 pm

RE: [PHP-DB] Request for help on (My)SQL Statement

So you're saying there's no way to do it in this version with a single statement? Thanks, John -Original Message- From: Micah Stevens [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 27, 2004 5:00 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Request for help on (My)SQL Stateme

Re: [PHP-DB] Request for help on (My)SQL Statement

> (406)447-4310 > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 27, 2004 4:52 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Request for help on (My)SQL Statement > > :::Novice Alert::: > > I've

RE: [PHP-DB] Request for help on (My)SQL Statement

alist Carroll College CCIT Helena, Montana (406)447-4310 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 27, 2004 4:52 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Request for help on (My)SQL Statement :::Novice Alert::: I've done simple select

[PHP-DB] Request for help on (My)SQL Statement

:::Novice Alert::: I've done simple select and insert statements, so I suppose this is the most complicated thing I've tried to do. but seems to me it should be pretty easy. But I'm a designer by background, not a developer or programmer. I've got everything else I'm trying to do working. I'