on 1/2/04 12:59 PM, Adam i Agnieszka Gasiorowski FNORD wrote:
Thanks for the info. Just so I'm sure I know what I should: :)
1) You only want the day's articles. These are records in the article table and
nowhere else.
2) An article will always belong to at least one section, and may belong to m
on 1/2/04 12:40 PM, Jeremy March wrote:
> What language are you using? It's not clear from your example what language
> you're using (no "$"s, but you also forgot to increment your array so?), so
> I'll give you an example in PHP:
You can still do better than that. IN will be more readable tha
on 1/2/04 12:59 PM, Adam i Agnieszka Gasiorowski FNORD wrote:
> Tell me if you need any additional information.
> Thank you for all your help.
Some additional information would help, yes. What exactly are the sections, for
example? Do you need to know the number of new _articles_ total, the new
on 1/1/04 9:59 PM, Schulman, Michael wrote:
> That only returns one number.. what we are really looking for is something
> like
>
> SELECT ticker, hour, first(price), last(price) from pricedata group by hour
Well, if you're using MySQL 4.1+, you're in luck. A subquery should help.
SELECT ticker
on 12/29/03 12:00 PM, Bjoern Wuest wrote:
> Hello
>
> I have the following problem:
>
> Table1 'pl':
> +---+---+
> | p | o |
> +---+---+
>
> Table2 'ln':
> +---+--+---+
> | p | l | v |
> +---+--+---+
>
> Now my problem: how to write a statement to select all 'p' and 'v' from 'pl'
>
on 12/29/03 9:54 AM, Dave G wrote:
> $wsQuery = "SELECT improvwsid FROM improvws WHERE wsdate > '" . $today
> . "' AND wsdate < '" . $sevenDays . "' AND cancelled = 0";
> $wsResult = mysql_query($wsQuery);
> $wsid = mysql_result($wsResult, 0, "improvwsid");
> $emailQuery = "SELECT members.email A
