Search:

Type: Posts; User: aussiemcgr

Search: Search took 0.07 seconds.

  1. Replies
    9
    Views
    1,473

    Re: Improving the SQL statement

    The php is not the client. It is a webservice the client uses to access the database because my webhost does not allow remote access to the database. The php code runs on the server, so it has local...
  2. Replies
    9
    Views
    1,473

    Re: Improving the SQL statement

    Well that is essentially all the webservices do. My program sends parameters to the php url. Then, based on the parameters used and all sorts of other stuff, it creates the SQL statement, sends the...
  3. Replies
    9
    Views
    1,473

    Re: Improving the SQL statement

    What do you mean by: "removing the SQL code and encapsulating it elsewhere"?
    The code in this php file is a webservice (one of twelve webservices) I am using to communicate with my server.
  4. Replies
    9
    Views
    1,473

    Re: Improving the SQL statement

    My primary reason is because it sort of "breaks the design" of the rest of the file (this file handles a bunch of different requests for interacting with the Company table in the database). I also do...
  5. Replies
    9
    Views
    1,473

    Improving the SQL statement

    I have a SQL statement which I would like to optimize. This code is in php, but I'm just worrying about the sql part, so I figured some people on this forum might have some advice.

    Basically, I...
Results 1 to 5 of 5