Switch Break or Better Idea

[phpretard]

I think a switch break will help in this situation but I am definitely open to suggestions

 

The problem I am have is that if there are 2 "Funner" or "Funnest" in the database then it displays duplicates in the in the column.

 

I know that is what the code is telling it to do.  If you look at the first row it should split them if there are 2 and display one in each column.

 

In one time slot there is only allowed:

- 1 Fun

- 1 Funner or Funnest

- 1 Funner or Funnest

 

The case I am working with is there is 1 Fun and 2 Funners. 

 

The 2 Funners should split and display one in each "Funner/Funnest" column.

 

There are planty of unique identifiers if someone has an idea for me.

function taken($theType, $theTime){

$day_view = $_GET['date'];
		$DOP = explode("-", $_GET['date']);
		$topDOP = date("M", mktime(0, 0, 0, $DOP['1']))." ".$DOP['2'].", ".$DOP['0'];
		$dayDOP = date("l", mktime(0, 0, 0, $DOP[1], $DOP[2], $DOP[0]));

connect();
$sql = "select * from party_times where dates = '$day_view' and paidID ='paid' and times = '$theTime'";
$result = mysql_query($sql) or die(mysql_error());
$day_count = mysql_num_rows($result);
while($info = mysql_fetch_assoc($result)){

	if($info['type'] == "$theType" && $info['times'] == "$theTime"){
		$conID = "select DISTINCT confirmID from party_receipt where partyID = '".$info['partyID']."'";
		$conqu = mysql_query($conID) or die(mysql_error());
		while($con = mysql_fetch_assoc($conqu)){

			$cid = $con['confirmID'];
			echo "<a href='party_booked.php?view=$cid'>RESERVED</a>";

		}free($conqu);
	}

}free($result);
}

Call the function:

  <tr>
    <td width="25%"></td>
    <td width="25%" align="center">Fun</td>
    <td width="25%" align="center">Funner / Funnest</td>
    <td width="25%" align="center">Funner / Funnest</td>
  </tr>
<tr>
    <td>11:00 AM</td>
    <td class = "res"><?php taken("Fun", "11:00 AM"); ?></td>
    <td class = "res"><?php taken("Funner", "11:00 AM"); ?></td>
    <td class = "res"><?php taken("Funnest", "11:00 AM"); ?></td>
  </tr>

 

Thank you!

[phpretard]

I though this might help explain -- Image Attached

 

I was able to shorten the function as well:

 

function taken($theType, $theTime){
connect();
$sql = "select * from party where DOP = '$day_view' and type = '$theType' and PTIME = '$theTime' and confirmed !='' ";
$result = mysql_query($sql) or die(mysql_error());
$day_count = mysql_num_rows($result);
while($info = mysql_fetch_assoc($result)){

		echo "<a href='party_booked.php?view=".$info['confirmed']."'>RESERVED</a>";

}free($result);

}

 

[attachment deleted by admin]

[phpretard]

bump