Advanced Search

Results 1 to 2 of 2

Thread: Creating a table from the results of a query?

  1. #1
    Join Date
    Sep 2007
    Location
    Maui
    Posts
    602
    Thanks
    266
    Thanked 13 Times in 13 Posts

    Default Creating a table from the results of a query?

    In phpMyAdmin, is there a way to create a table from the results of a query that takes data from multiple tables? Or maybe to load an existing table with the results of a query? Or do you need to do it from the shell?

    This select command lists the data I want in my table, but how do I get it into the table? Thanks. e

    Code:
    SELECT SubscribeDate, Email, Value, ListName 
    FROM `members` , `list_field_values` , `lists` 
    WHERE members.MemberID = `list_field_values`.UserID 
    AND `list_field_values`.FieldID =1 
    AND `members`.ListID = `lists`.ListID 
    ORDER BY `members`.`Email` ASC;
    Last edited by kuau; 06-01-2008 at 09:57 PM. Reason: forgot code tags

  2. #2
    Join Date
    Mar 2008
    Posts
    218
    Thanks
    7
    Thanked 19 Times in 19 Posts

  3. The Following User Says Thank You to tfit For This Useful Post:

    kuau (08-03-2008)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •