List question

Arc

I have a list that holds Dates taken from a DB. And each item also has a value which is an autoincrement Number. This is so if there are 2 dates the same i can tell them apart with the auotincrement number.

My problem is how do i get the value of the list item AND the Date?

Example: This populates a listbox with items for the DB..ResultArray[0] is the Unique Key ResultArray[1] is the Date

Print "<select name=\"selPaymentDate\">";
While ($ResultArray = @mysql_fetch_array($Result)){
              Print"<option value="$ResultArray[0]">$ResultArray[1]</option>";
     }
 Print "</select>";

So how do i get both of those values out of the list?

THanks!!

😃

picker999

//following query cannot be incorporated into following query to teamMember
//as it collects multiple registrations for array $TMrow.
$resultmbr=mysql($dbName, "SELECT TeamMemberID, DivisionMemberID
FROM ITTeamMember
WHERE PlayerID='$session' AND LeagueID='$leagueID'") or die("Could not find the user and password.");
$TMnum = mysql_affected_rows();

//for loop checks for multiple team/division membership as well as pull values from tables
for($i=0;$i<$TMnum;$i++)//if nothing else this may be useful for error checking problems due
{ //to multiple entries. Arrays are loaded and printed below in the
$TMrow = mysql_fetch_row($resultmbr);//numerous foreach statements beginning on line 170
$TM[$i] = $TMrow[0];
$TMdiv[$i] = $TMrow[1];

            $resultTeamID=mysql($dbName, "SELECT TeamID
                                         FROM ITDivisionMember
                                         WHERE DivisionMemberID='$TMdiv[$i]' AND LeagueID='$leagueID'")  or die("Could not find the user and password.");
            $TMIDrow = mysql_fetch_row($resultTeamID);
            $TMID[$i] = $TMIDrow[0];

            $resultTeamNM=mysql($dbName, "SELECT TeamName, TeamContact1ID, TeamContact2ID
                                         FROM ITTeam
                                         WHERE TeamID='$TMID[$i]' AND LeagueID='$leagueID'")  or die("Could not find the user and password.");
            $TMNMrow = mysql_fetch_row($resultTeamNM);
            $TMNM[$i] = $TMNMrow[0];
            $TM1CT[$i] = $TMNMrow[1];
            $TM2CT[$i] = $TMNMrow[2];

            $resulta = mysql($dbName, "SELECT TeamMemberReg, TeamMemberStatus
                                      FROM ITTeamMember
                                      WHERE TeamMemberID='$TM[$i]'") or die("Could not find the user and password.");
            $rowa = mysql_fetch_row($resulta);
            $teamMemberReg[$i] = $rowa[0];
            $teamMemberStatus[$i] = $rowa[1];
            }

Arc

and what is that mess suppose to mean?

picker999

Mess? I thought it was elegant myself.
:-)

If you want to differentiate between two identical entries (In your case I believe it was dates) use the mysql_affected_rows()
and then the rest of the "mess" shows how to load arrays with what ever other information comes with the individual iterations of the identical date. In the example given it was necessary to find all the teamplayer registrations going under the identical teamplayer name. In other words the team player was registered to several teams simultaneously. (leagues and teams being tied together with primary keys therefore queries to several different tables as well.

Arc

I think you have totaly missed the point of my question.

I dont need a diffrent kind of query.... I need to know how to get the Value of a list item in 1 Variable and the TExt that is actually shown in the list as a DIfferent Variable.

If i have a list with 1 item and You see "BLEH" but it's value is "5" How do i set " BLEH" to one variable and "5" to another?

When you post a list to a php page you just pass the name of the list..isnt there some way to pass the Value AND the text that is actually shown?

See?

Print "<select name=\"selPaymentDate\">";
Print"<option value="BLEH">5</option>";
Print "</select>";

In that list, BLEH Is the Value, but the Number 5 is what you see. Any way to get and pass both those values to another page?

THanks!😃

picker999

It is not query itself in the code that I gave you that is relevent here. It is the loading and unloading of the arrays using the for loop. Don't use the while loop. Unload the arrays into your list box using mysql_affected_rows()
to know where to stop incrementing $i.
You build your list box by using the for loop and unloading the array at the same time. I think you kind of had the idea that some sort of a loop was necessary. In your original post you had while(x=y) which would not work. maybe while(x==y) But you still don't know the differences of your index associated with the identical date. So you use mysql_affected_rows() to count how many duplicate dates there are and then load your arrays from the $result of your query. Then build your list box and unload the arrays into the list item. You can pass arrays to other pages by using the "hidden" switch and "post" in your form.

dnszero

It sounds like your question is primarily an html one, "How to get 1 select box to pass 2 variables".

You dont't really need to do this at all, simply set the Value of each item to the AutoIncrementing ID field of your db row. Then you can keep track of everything by passing just one variable... With this method, if you need the Date (or any other info) on the next page, just look it up with one really quick query.

Arc

Picker you are way off in left field man. But dnszero... yah it would make sense to only pass the AutoID..BUT the problem is the USer picks a date from a List not an ID...And on the next page i have to update this stuff...so i need not only the Date but also the ID becasue there may be duplicate dates.

So i have to somehow pass the date AND the ID...

I could write the ID AND the Date in the list and pass them as 1 variable then parse it and get the 2 variabls back out..but that would look ugly..

dnszero

Yes, but the fact that they are picking a date doesn't matter becuase, according to your example code in initial post, that date is coming out of your db... So if you just lookup the autoid that they select then you will also know the date that they picked. The fact that there can be multiple dates doesn't matter that way.

kinadian

I think I know what you are asking, and I think I know the solution.

You want to specify which columns are included within your query. I'm just going to say the column with the number is called Number and the date column is called Date.

Your query would be

SELECT Number,Date FROM dates WHERE (whatever conditions you want).

Then you grab your result and put it into an array like this:

while ($query_data = mysql_fetch_array($result)) {
$number = $query_data["Number"];
$date = $query_data["Date"]

//Do whatever you want with the variables

}

The while loop's condition will automatically grab each row one at a time and assign the var $number & $date the values. You'll have to use them in the loop, since they will be overwritten next iteration. Or, if you wanted to keep them you could do something along these lines:

$FirstTime = TRUE;
while ($query_data = mysql_fetch_array($result)) {
if ($FirstTime) {
$number = array ($query_data["Number"];
$date = array ($query_data["Date"];
$FirstTime = FALSE;
}
else {
array_push ($number, $query_data["Number"]);
array_push ($date, $query_data["Date"]);
}
}

That is, if I understood your question right 🙂

--kinadian