RE: [PHP-DB] Request for help on (My)SQL Statement
| From: | Swan, Nicole | Date: | Tue, 27 Apr 2004 23:16:30 +0000 |
| Subject: | RE: [PHP-DB] Request for help on (My)SQL Statement | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-34126@lists.php.net to get a copy of this message | ||
You're right, of course, Micah. I guess I've been using my development server (which has
MySQL 4.1a) for so long, that I've forgotten. :)
I guess, then, that two queries would need to be used instead.
--Nicole
-----Original Message-----
From: Micah Stevens [mailto:micah@raincross-tech.com]
Sent: Tuesday, April 27, 2004 5:00 PM
To: php-db@lists.php.net
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, Swan, Nicole wrote:
> Have you tried a nested query? I think your problem is that you're really
> using information from two different tables.
>
> Maybe:
>
> UPDATE ngc_polling SET lastrundate = (SELECT max(post_time) FROM
> nuke_phpbb_posts);
>
>
> --Nicole
> ---------------------------
> Nicole Swan
> Web Programming Specialist
> Carroll College CCIT
> Helena, Montana
> (406)447-4310
>
>
> -----Original Message-----
> From: John.Bedard@ngc.com [mailto:John.Bedard@ngc.com]
> Sent: Tuesday, April 27, 2004 4:52 PM
> To: php-db@lists.php.net
> Subject: [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'm trying to take the largest value out of one table and update another
> table. The former is a PHPBB table and the latter is a table I created just
> to store the value of the date of the most recent post for use in something
> else.
>
> UPDATE ngc_polling SET lastrundate = max(nuke_phpbb_posts.post_time)
>
> It returns "Invalid use of group function."
>
> I've been looking at the documentation on MySQL.com to no avail. I'm
> testing my query in phpMyAdmin before I try to implement it elsewhere. This
> is what I'm trying to do, any help besides "RTFM" (been doing that) would
> be greatly appreciated.
>
> Thanks!
>
> John
>
> John Bedard | Interaction Designer (SWEIII) | Northrop Grumman Mission
> Systems | Helena, Montana, U.S.A. | john.bedard@ngc.com | 406.443.8630 |
> Fax 406.443.8601 |
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php