You can try adding a quick test to the ON statement...
SELECT * FROM TableA
INNER JOIN TableB
ON TableA.record_id = TableB.record_id
AND TableB.timestamp = MAX(TableB.timestamp)
Now, I haven't tested it.
I can only say the theory of it is accurate.
- Jon L.
On Thu, Mar 6, 2008 at 12:46
should check out the following page on adding users:
http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
And read up on the following commands:
CREATE USER: http://dev.mysql.com/doc/refman/5.0/en/create-user.html
GRANT: http://dev.mysql.com/doc/refman/5.0/en/grant.html
- Jon L.
On Sat, Mar 8
`
Status: b:1; (1)
Error : '' (0)
Closing connection
Status: b:1; (1)
Error : '' ()
- Jon L.
On Sat, Mar 8, 2008 at 5:53 PM, Manysh [EMAIL PROTECTED] wrote:
Thanks for your input, Jon. Few more observations...
Yes, I have PHP+Apache+MySQL installed for private use
it, as Matt suggested, using IN: WHERE variable IN (1, 2)
Did that help any?
- Jon L.
On Mon, Mar 10, 2008 at 3:40 PM, Neil Smith [MVP, Digital media]
[EMAIL PROTECTED] wrote:
At 19:34 09/03/2008, you wrote:
From: Ron Piggott [EMAIL PROTECTED]
Date: Sun, 09 Mar 2008 15:34:05 -0400
Message-Id
, if you use IN, the listing_type tests will already be grouped.
WHERE name LIKE ABC AND listing_type IN (1, 2)
- Jon L.
On Mon, Mar 10, 2008 at 4:02 PM, Jon L. [EMAIL PROTECTED] wrote:
Now I've spoon fed you
Damn, Neil...you're a d-bag.
Next time you go to offer help, it may assist you
[Correction]
Change:
Also, reversing the order should work (since grouping is left-to-right):
To:
Also, reversing the order should work (since AND/OR/etc. are read
left-to-right):
- Jon L.
On Mon, Mar 10, 2008 at 4:18 PM, Jon L. [EMAIL PROTECTED] wrote:
As much as I hate admitting
;
$nums = string_to_array(preg_replace(/[^0-9]+/, , $nums));
- Jon L.
On Wed, Mar 26, 2008 at 1:35 PM, Richard Dunne [EMAIL PROTECTED]
wrote:
Using this extract from
http://ie.php.net/manual/en/control-structures.foreach.php
Amaroq
09-Mar-2008 06:40
Even if an array has only one value
Here's the manual: http://php.net/language.types.resource
Also: http://php.net/resource
An entire list of all possible resource types and respective functions.
Read up, man.
- Jon L.
On Mon, Mar 31, 2008 at 1:39 PM, Richard Dunne [EMAIL PROTECTED]
wrote:
When I did a search on resource(5
What I get for not refreshing. ;)
Sorry, man. Didn't know you already gave the links.
- Jon L.
On Mon, Mar 31, 2008 at 1:56 PM, Andrés G. Montañez
[EMAIL PROTECTED] wrote:
The ID of the resource changes on every new resource.
There is no co-relation between resources and resources id
(This isn't a solution, per se...just a suggestion.)
I don't know how they compare; I've never personally used the ODBC
functions...
But, you may give the MSSQL functions a try:
http://php.net/mssql
- Jon L.
On Mon, Mar 31, 2008 at 3:27 PM, cfs [EMAIL PROTECTED] wrote:
I'm using PHP
.
- Jon L.
On Thu, Apr 3, 2008 at 6:57 PM, Nasreen Laghari [EMAIL PROTECTED]
wrote:
Hi,
I'm trying to put limit of data fetch as well as dynamic navigation. Below
is the try which I did but something is going wrong as $screen value is not
increasing so when I click on NEXt button it refreshes
());
while ($row = mysql_fetch_array($result))
{
echo Program is in While loop;
$g_name = $row[gig];
$vname = $row[venue];
$genre = $row[genre];
echo(Gig Name: .$g_name);
}
- Jon L.
On Tue, Apr 29, 2008 at 1:27 PM, Nasreen Laghari [EMAIL PROTECTED]
wrote:
Hi,
Why my
)) {
alert('Please enter an integer for ...');
}
}
- Jon L.
On Mon, May 12, 2008 at 11:47 AM, YVES SUCAET [EMAIL PROTECTED] wrote:
Nope, it's not. The problem was formulated as Integer detection. not
numerical detection in general. isNaN will return positive for e.g.
floating
point values
13 matches
Mail list logo