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...
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...
...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";
$resultA=mysql_query($queryA);
while($rowH=mysql_fetch_array($resultH)...
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...
...Catalog=CSB;Data Source = SRB2;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096"
conn.Open sConnString
rs.Open "SELECT * FROM moderator_tbl WHERE accnt_nmbr like '555-555-9034*' ORDER BY dt_added DESC", conn, adOpenStatic, adLockReadOnly
Do Until rs.EOF
A =...
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...
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...
Thanks, problem is it's not working the way I want it too, maybe it's the way I'm doing it?
See the way I named the text boxes <input name='txtInput[]' size='5'>, I'm using the [] for array purposes in PHP when submitting a form. This [] is what seems to be causing the problem, now I cannot...
Hail,
Let's say I have three text boxes in my submit form that I name the same to put in an array:
<input name='txtInput[]' size='5'>
<input name='txtInput[]' size='5'>
<input name='txtInput[]' size='5'>
If I want to know the value of textbox # 2, how would I do that?
I thought:
msgbox...
Hail,
I have reports that export to HTML which works well but all my listboxes are not showing any data? Furthermore, any other formatting in code is also ignored? Is there a way around this?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.