I'm looping through the results of a database query and then through a text file to compare variables and build a string but I'm having problems with comparing them effectively. Here's the way I'm doing it now:
$numOfRows = mysql_num_rows ($result);
for ($i = 0; $i < $numOfRows; $i++){
$roomName = mysql_result ($result, $i, "roomName");
$roomURL = mysql_result ($result, $i, "roomURL");
$groupName = mysql_result ($result, $i, "groupName");
$readfile1 = file("rooms.txt");
for ($d=0; $d<=count($readfile1); $d++) {
$un = split("\t",$readfile1[$d]);
$un = array_map("trim", $un);
if($groupName == "hang_outs"){
if($roomURL == $un[0]){
$hang = "<option value=$roomURL>$roomName($un[2])</option>".$hang;}
else{
$hang = "<option value=$roomURL>$roomName</option>".$hang;}
}
if($groupName == "peers"){
if($roomURL == $un[0]){
$peers = "<option value=$roomURL>$roomName($un[2])</option>".$peers;}
else{
$peers = "<option value=$roomURL>$roomName</option>".$peers;}
}
if($groupName == "interests"){
if($roomURL == $un[0]){
$interests = "<option value=$roomURL>$roomName($un[2])</option>".$interests;}
else{
$interests = "<option value=$roomURL>$roomName</option>".$interests;}
}
if($groupName == "regional"){
if($roomURL == $un[0]){
$regional = "<option value=$roomURL>$roomName($un[2])</option>".$regional;}
else{
$regional = "<option value=$roomURL>$roomName</option>".$regional;}
}
if($groupName == "adult"){
if($roomURL == $un[0]){
$adult = "<option value=$roomURL>$roomName($un[2])</option>".$adult;}
else{
$adult = "<option value=$roomURL>$roomName</option>".$adult;}
}
if($groupName == "help"){
if($roomURL == $un[0]){
$help = "<option value=$roomURL>$roomName($un[2])</option>".$help;}
else{
$help = "<option value=$roomURL>$roomName</option>".$help;}
}
}
}
The problem is here:
else{
$hang = "<option value=$roomURL>$roomName</option>".$hang;}
Every time the values don't match it's adding onto the variable leaving me with extra <option>'s that aren't supposed to be there! I've been messing with this for hours and I can't figure it out! Help please!
