Recent content by Phailak

Works like a charm, thanks

Thanks, I'll give it a try tonight!

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...

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

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...

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"...

Thanks guys, subquery it is

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...

LOL, that was so simple it hurts! Thanks!

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...

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

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...

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...

I used a multiarray which worked out great, thanks!

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...