Professional Web Applications Themes

Easier queries? - PHP Development

Here's what I'm thinking, just looking to see if anyone has done this or similar. - I have a MySQL DB and I create an ODBC datasource for it on my windows box - I then open MS Access and link the tables from my datasource - Access provides a graphical relationship builder, so I build relations in this - Access also provides a graphical query builder that uses the stored relationships - So I build a query, view the SQL and use the SQL code in some mysql_ PHP functions - Maybe next I instead save the queries in ...

  1. #1

    Default Easier queries?

    Here's what I'm thinking, just looking to see if anyone has done this or
    similar.

    - I have a MySQL DB and I create an ODBC datasource for it on my windows box
    - I then open MS Access and link the tables from my datasource
    - Access provides a graphical relationship builder, so I build relations in
    this
    - Access also provides a graphical query builder that uses the stored
    relationships
    - So I build a query, view the SQL and use the SQL code in some mysql_ PHP
    functions

    - Maybe next I instead save the queries in a query table so I can get them
    via simple name, like 'All_Customers'
    Sort of ogous to MS SQL Views?

    Sound good, or is there a better way?

    TIA
    -Shawn

    P.S. I've also seen mention of some graphical query builders. Can anyone
    recommend a good FREE one?


    Shawn McKenzie Guest

  2. #2

    Default Re: [PHP] Easier queries?

    > Here's what I'm thinking, just looking to see if anyone has done this or
    > similar.
    >
    > - I have a MySQL DB and I create an ODBC datasource for it on my windows
    > box
    > - I then open MS Access and link the tables from my datasource
    > - Access provides a graphical relationship builder, so I build relations
    > in
    > this
    > - Access also provides a graphical query builder that uses the stored
    > relationships
    > - So I build a query, view the SQL and use the SQL code in some mysql_
    > PHP
    > functions
    >
    > - Maybe next I instead save the queries in a query table so I can get them
    > via simple name, like 'All_Customers'
    > Sort of ogous to MS SQL Views?
    You may want to consider switching to PostgreSQL which supports views, as
    well as cascading updates among tables with foreign key constraints.
    However, since it requires cygwin to run on MS Windows it is not the best
    for cross platform solutions.
    >
    > Sound good, or is there a better way?
    >
    > TIA
    > -Shawn
    >
    > P.S. I've also seen mention of some graphical query builders. Can anyone
    > recommend a good FREE one?
    >
    >
    >
    > --
    > PHP General Mailing List ([url]http://www.php.net/[/url])
    > To unsubscribe, visit: [url]http://www.php.net/unsub.php[/url]
    >
    >

    --
    Thanks,
    Dean E. Weimer
    [url]http://www.dwiemer.org/[/url]
    [email]dweimerdweimer.org[/email]
    Dean E. Weimer Guest

Similar Threads

  1. Queries Of Queries Single Quote Problem
    By TimH2O in forum Macromedia ColdFusion
    Replies: 0
    Last Post: April 1st, 07:46 PM
  2. [PHP] easier than switch
    By John W. Holmes in forum PHP Development
    Replies: 7
    Last Post: August 18th, 02:52 PM
  3. [PHP] Is there an easier way?
    By David Nicholson in forum PHP Development
    Replies: 0
    Last Post: August 1st, 01:08 AM
  4. Is there an easier way?
    By Ryan A in forum PHP Development
    Replies: 0
    Last Post: August 1st, 01:03 AM
  5. Tell me how it was easier???
    By Delores Highsmith in forum Macromedia Freehand
    Replies: 3
    Last Post: July 22nd, 05:36 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139