Chris,
>select count(distinct uid) as c
>from aptg_guides_restricted as r, aptg_guides as g
..
See the extensive notes on comma and SQL2003 joins at
http://dev.mysql.com/doc/refman/5.1/en/join.html.
Lose the comma join, make it a SQL2003 (explicit inner) join.
PB
-
At 15:56 +0200 25
At 11:10 -0500 25/4/06, gerald_clark wrote:
Yes. 3.23 was not correct in the order of precedence.
This has been answered many times here.
Sorry - I haven't been on the list all that long.
You need to change your comma join to an inner join.
Lovely! That's it - many thanks.
At 17:15 +0100 2
2006/4/25, Chris Sansom <[EMAIL PROTECTED]>:
> At 15:56 +0200 25/4/06, Barry wrote:
> >And you don't see any misdone queries when you echo them, right?
> >Hope you checked that.
>
> Hi Barry
>
> I was wrong about its being a PHP issue: it's
> definitely a MySQL error. I realised I hadn't
> handled
Chris Sansom wrote:
At 15:56 +0200 25/4/06, Barry wrote:
And you don't see any misdone queries when you echo them, right?
Hope you checked that.
Hi Barry
I was wrong about its being a PHP issue: it's definitely a MySQL
error. I realised I hadn't handled the error in such a way that I
cou
At 15:56 +0200 25/4/06, Barry wrote:
And you don't see any misdone queries when you echo them, right?
Hope you checked that.
Hi Barry
I was wrong about its being a PHP issue: it's
definitely a MySQL error. I realised I hadn't
handled the error in such a way that I could see
what it was, but
At 15:56 +0200 25/4/06, Barry wrote:
Updating is always such a bad idea ;P
Do you know: never touch a running system? ^_^
Hmmm...
And you don't see any misdone queries when you echo them, right?
Hope you checked that.
Yes, they look just fine - in any case they're unchanged from when it
wa
Chris Sansom schrieb:
As a relative newbie, and an almost total newbie to the use of left
joins, I'm aware that there's some difference in the way joins work
between MySQL 3.x and 5.x, but in my ignorance I can't figure out what
the heck it is from reading the 'upgrading' pages on dev.mysql.com
As a relative newbie, and an almost total newbie to the use of left
joins, I'm aware that there's some difference in the way joins work
between MySQL 3.x and 5.x, but in my ignorance I can't figure out
what the heck it is from reading the 'upgrading' pages on
dev.mysql.com.
When I first joine
