CodingForums.com - Search Results

SMS enable your application via Clickatell’s fast, simple and reliable API's, built to integrate with any system. Click here to learn more.

Flash Website Builder- Trendy Site Builder is a Flash Site Building tool that helps users build stunning websites.

Check Out Custom Custom Logo Design by LogoBee. Website Design and Free Logo Templates available.

		CodingForums.com > Search Forums
Search Results

Before you post, read our: Rules & Posting Guidelines

Showing results 1 to 6 of 6
Search took 0.04 seconds. Search: Posts Made By: katyD

Forum: MySQL

04-27-2012, 08:16 PM

Replies: 10

Having problems with UNION and GROUP, help greatly appreciated

Views: 872

Posted By katyD

Okay, with Old Pendant's help, I've finally got...

Okay, with Old Pendant's help, I've finally got something which seems to be pretty close to what I was looking for? I've been looking at it too long to get into all the nit-picking details, but this...

Forum: MySQL

04-27-2012, 05:27 PM

Replies: 10

Having problems with UNION and GROUP, help greatly appreciated

Views: 872

Posted By katyD

I've been doing some more testing, and there is...

I've been doing some more testing, and there is actually one row missing from this result, vs. my original query, where pageName='Area Information'. I think it is now just getting the section names,...

Forum: MySQL

04-27-2012, 04:06 PM

Replies: 10

Having problems with UNION and GROUP, help greatly appreciated

Views: 872

Posted By katyD

Thanks Old Pendant! That is close, but it...

Thanks Old Pendant! That is close, but it shouldn't be showing duplicate catIDs. The subsetOf establishing the hierarchy of the items in the pagesCats table, so it ties to the pagesCats.ID

Forum: MySQL

04-27-2012, 01:00 AM

Replies: 10

Having problems with UNION and GROUP, help greatly appreciated

Views: 872

Posted By katyD

I'm so sorry, I'm clearly having one of those...

I'm so sorry, I'm clearly having one of those days.
I've attached a new zip with all 3 tables included.

I'll try to explain my problem a bit better. The problem part of the query is this bit:...

Forum: MySQL

04-26-2012, 03:02 PM

Replies: 10

Having problems with UNION and GROUP, help greatly appreciated

Views: 872

Posted By katyD

Sorry for the sore head The database...

Sorry for the sore head

The database structure (simplified), is:

TABLE: pages
ID
pageName
webName
sortBy

Forum: MySQL

04-18-2012, 03:20 PM

Replies: 10

Having problems with UNION and GROUP, help greatly appreciated

Views: 872

Posted By katyD

Having problems with UNION and GROUP, help greatly appreciated

Good morning all!
I'm having an issue, and I think I know what my problem is, but don't know quite enough to solve it.

Basically, I have three tables:
pages (contains all the information to...

Showing results 1 to 6 of 6

Forum Jump

All times are GMT +1. The time now is 05:31 PM.