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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Phailak

  1. Phailak

    Where clause that gets first of each group

    Works like a charm, thanks
  2. Phailak

    Where clause that gets first of each group

    Thanks, I'll give it a try tonight!
  3. Phailak

    Where clause that gets first of each group

    I have a table that has a scandate, name and other customer data. The problem is the application duplicates the customer information with each new scan like: 2007-05-25 George M 45 50$ 2006-08-08 Allie F 50 70$ 2005-07-07 Allie F 50 80$ 2004-05-05 Allie F 50 90$ I want to extract one record...
  4. Phailak

    Two conditions in a while loop

    You're right, I changed the query and it worked, thanks!!!
  5. Phailak

    Two conditions in a while loop

    It doesn't work, I get an error on this line: while($rowH=mysql_fetch_array($resultH) OR $rowA=mysql_fetch_array($resultA)) The error is (shows twice as if each statement is wrong???): Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program...
  6. Phailak

    Two conditions in a while loop

    Hail, Can you put two conditions in a while loop? Reason I want to know is I have two arrays I want to loop through, only stopping the loop when BOTH are eof. Something like: $queryH="SELECT * FROM Goals"; $resultH=mysql_query($queryH); $queryA="SELECT * FROM Assists"...
    • Phailak
    • Thread
    • Replies: 4
    • Forum: PHP
  7. Phailak

    Display a field not part of the group by?

    Thanks guys, subquery it is
  8. Phailak

    Display a field not part of the group by?

    Hail, I have 4 fields: tName, tDate, tTime, TotalUtilizationAvg (this field in in %) What I need is to get the max amount from the Utilization field per day per Name which I do like so: SELECT tName, tDate, max(TotalUtilizationAvg) as MaxUtil FROM Traffic GROUP BY BridgeName, TrafficDate...
  9. Phailak

    Recordset is 0 but should not be?

    LOL, that was so simple it hurts! Thanks!
  10. Phailak

    Recordset is 0 but should not be?

    Hail, I tried to puzzle this out all morning, I usually use DAO but I know it's not very efficinet with SQL so I'm trying to use ADO now. Anyway, the recordset below is returning 0 records when I know that specific query returns records, I'm wondering if it has to do with something I'm doing...
  11. Phailak

    Count of multiple fields

    Yeah, it makes sense, I never took the time to analyse it before since it came to me that way, I guess it's worth the work to seperate the table and rewrite the scripts... I'll give it a try to see how well it works! Thanks for the advice
  12. Phailak

    Count of multiple fields

    Look at it this way, let's say we have player ID 25 and player ID 32 on the same team. ID 25 scored two goals and assisted on a third let's say and obviously they both have a game played so the data would look like GameID GP G A Period Time 1 25 0 0 0 null 1 32 0 0 0...
  13. Phailak

    Count of multiple fields

    Hail, I have a database that stores some stats for a hockey league in the following manner: Field names are GP, G, A Whenever a player Plays a game, his ID is added to the column GP while other columns go to 0 If a player scores a goal, his ID goes under G, the guy who assisted goes under A...
  14. Phailak

    Types and their elements

    I used a multiarray which worked out great, thanks!
  15. Phailak

    Types and their elements

    Hail, Let's say you have: Public Type Test Test1 as string Test2 as string Test3 as string End Type Is there a way to loop through the elements? For example, let's say I would want to assign three values (1, 2 and 3) to each of those, is there a way to loop them instead of doing Dim...
See more

Part and Inventory Search

Back
Top