Thanks everyone very much for help. Here is a working query:
SELECT c.name, COUNT(X.name) FROM cats c
LEFT JOIN
(
SELECT i.`name`, i.catid, COUNT(*) as ct
FROM items i
INNER JOIN...
Type: Posts; User: likwid; Keyword(s):
Thanks everyone very much for help. Here is a working query:
SELECT c.name, COUNT(X.name) FROM cats c
LEFT JOIN
(
SELECT i.`name`, i.catid, COUNT(*) as ct
FROM items i
INNER JOIN...
Thanks for reply.:)
Looks like EXISTS works but I think I still need a join, otherwise the query recognises that the combination of tokens exist and returns all categories.
Thanks all for replies.
DrMelon, That doesn't work I'm afraid.
pp and kernel, It looks indeed like it's multiple joins which is a total pain as there will be varying numbers of tokens. I can...
SET FOREIGN_KEY_CHECKS = 0;
CREATE TABLE `cats` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(100) NOT NULL,
`des` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY...
I'm having a hellish time with a mysql query.
It goes like this. I have three tables, one is of items, another of categories which each item falls into one of, the other tokens which each item has...
Hi.
I'm having a lot of problems figuring out the best way to do this.
Basically I want to iteratively update an object of varying depth, that is objects of objects of object etc which in fact...
Hi
I'm looking to track the position of the mouse relative to the DOM. What I would like is a function which returns the defined id of the innermost html element (not text node). Any advice would...
It doesn't ignore empty lines :)
Unfortunately does not work with Samsung R60plus.
Thanks very much :)
It's a shame javascript seems pretty limited for inbuilt functions but I'm really enjoying using it nonetheless.
Hi
That would work, in fact the split function loads the textarea into an array. I was hoping there would be a delimiter that I could use within split.
Hi
Is it possible to split the contents of a text box into rows while ignoring empty lines, using split? It's possible in php but i can't find anything for js.
Thanks :)
The problem is the lack of a real summer. The weather's rubbish here, we even had hail stones week before last. We have quite large windows in our flat, it's pretty old. I think a vauxhall nova air...
An awning! :)
I assumed the cold damp air is being sucked through the air intake. Maybe it wouldn't be a problem, but for the fact that we have bare floorboards in our flat. I think my only choice...
Hi
I was having problems over the last few months with a media box in our living room freezing up randomly.
Having tried everything to troubleshoot, spending hours swapping ram, cpu,...
My problem with :
CIFS VFS: Server not responding
seems to have gone away. Not sure how. Worth mentioning, i installed debian etch amd it originally exhibited the same problems, so it seems...
That didn't help i'm afraid. The only apparent difference was that my drives were also mounted in /media.
I'm using fstab
Thanks dmizer for howto, it's really helpful.
I'm having this same problem after a new installation.
http://amarok.kde.org/amarokwiki/index.php/MySQL_HowTo
There's a couple of semicolons missing from end of mysql commands.