Search found 8 matches

by thdrought
Thu Jul 13, 2006 6:20 am
Forum: Databases
Topic: Creating a recordset from two tables
Replies: 15
Views: 955

If you run the query in phpMyAdmin it should return the execution time above the result set. Now I see it. It states "3 total, Query took 0.0092 sec" I ran the original query again, and that one states "1 total, Query took 0.0070 sec ". So, the impact of showing all the records ...
by thdrought
Wed Jul 12, 2006 1:25 pm
Forum: Databases
Topic: Creating a recordset from two tables
Replies: 15
Views: 955

Everah wrote:Now that is a query. I'd be interested to see the execution time on that thing.
How do I get that info? I only have access to phpMyAdmin screen. Is there something I can run with the query to display it? Then I'll do a before and after.
by thdrought
Wed Jul 12, 2006 1:12 pm
Forum: Databases
Topic: Creating a recordset from two tables
Replies: 15
Views: 955

Well, I got it to work just fine now. Some of the fields that I was having problems with, see above, have been either eliminated or combined with other fields. Here's the results. Thanks everyone. :D (SELECT 't' as thread_type, tt.thread_time_id as thread_id, tt.ticket_id as ticket_id, tt.thread_tim...
by thdrought
Wed Jul 12, 2006 12:15 pm
Forum: Databases
Topic: Creating a recordset from two tables
Replies: 15
Views: 955

You can "cheat" with a union query: Well, that is a lot of use to me. I had to make a few mods to get it to work. It's just a starting point right now, and Ill need to clean it up before making it live. But, here's what I learned from this. for each field thats blank, I had to define it w...
by thdrought
Wed Jul 12, 2006 5:34 am
Forum: Databases
Topic: Creating a recordset from two tables
Replies: 15
Views: 955

A 'Union' query was my first instinct too, and I tried it. It failed saying that the fields were different. After more research, I found Unions would only work if all the fields were the same.
by thdrought
Tue Jul 11, 2006 2:27 pm
Forum: Databases
Topic: Creating a recordset from two tables
Replies: 15
Views: 955

It is one heck of a query, but try this... First, thank you for helping. I tried the code above and entered 1 ticket number. This particular ticket has 8 records in the first "ticket reply" table and 3 records in the "ticket time tracking" table. When I ran the code, it combined...
by thdrought
Tue Jul 11, 2006 1:56 pm
Forum: Databases
Topic: Creating a recordset from two tables
Replies: 15
Views: 955

You hacking the cerberus code? :) -- I had to do that for my company a few months back. YES! You have to hack the code. It has great potential, but, until that potential is finally realized... :? I've made about 5 major changes to the 3.1 code, and have another few too do. Even found some errors th...
by thdrought
Tue Jul 11, 2006 10:28 am
Forum: Databases
Topic: Creating a recordset from two tables
Replies: 15
Views: 955

Creating a recordset from two tables

Weirdan | Please use , and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color] I am t...