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
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/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 than a
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 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 AS email,
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'
and 'ln' where