Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. LinnCounty

    PHP query not returning proper number of rows.

    I had an older release of the iSeries Client on my Webserver, so I updated it to the latest (v5r4) which updated the ODBC drive, and viola.. works great.
  2. LinnCounty

    WHERE a = bcd

    I'm using DB2 and did not have enough luck with this as I'd hoped. It looks like the fields in TABLE2 are just not meant to be joined like this. I have found a work around that gets me where I need to go. Thanks for your help, maybe I'll get to use this in the future.
  3. LinnCounty

    PHP query not returning proper number of rows.

    I have a PHP script that connects to our IBM DB2 Server (as400). When I run $query = "SELECT COUNT(row) FROM table"; $execute = odbc_exec($conn,$query); $result = odbc_fetch_array($execute); I get a response of 6611. but when I run $query = "SELECT row FROM table"; $execute =...
  4. LinnCounty

    WHERE a = bcd

    Ah.. the pipe dream perfect. I will try it out. THANK YOU!!!
  5. LinnCounty

    WHERE a = bcd

    I don't have time to search anymore. I can not find the proper keyword. I need help with a JOIN or a WHERE expression. TABLE1 contains CASE_NUMBER TABLE2 contains DEPT,YEAR,NUMBER CASE_NUMBER is DEPTyearNUMBER How do I format a JOIN or WHERE statement to use this info?

Part and Inventory Search

Back
Top