<?php
include 'includes/dash_header.php';
include 'includes/dash_links.php';
include 'includes/db_connection.php';
?>


<div class="span8">
                    <div class="row-fluid">
                      <div class="span9">
                        
                        <form>
                      		<fieldset>
                      			<legend>Your Subscriptions</legend>
                      			<h1>Your valid services  </h1>
                            <hr>

                      			<div>
                      				<?php

                      				// check user subscriptions 

                      				$phoneNumber = $_SESSION['phoneNumber'] ; 
						
						
                      				$query = "SELECT * FROM `ser_trace` WHERE `Cus_num` = $phoneNumber";
                      				$result = mysql_query($query);
                      				// check if user have subscriptions 

                      				$row = mysql_fetch_array($result);
                      				$service_id = $row['Service_id'];
                      				$count = mysql_num_rows($result);

                      				if ($count == 0 ) {
                      					echo "<p>You Are Not Subscribed in any service </p>";
                      				} else {
                      				/*
                      					$service_name_query = "SELECT * FROM `services` WHERE `Service_id` = $service_id";
                      					$service_name = mysql_query($service_name_query);
                      					$service_row = mysql_fetch_array($service_name);

                      					$service_info =  $service_row['Description'];

                      					*/

                      					  $query = "SELECT * FROM `ser_trace` WHERE `Cus_num` = $phoneNumber";
                      				    $result = mysql_query($query);

                      				    while ( $row = mysql_fetch_array($result)) {
                      				    	//echo $row['Service_id'] . "<br>";
                                    $id = $row['Service_id'];
                                    $service_name_query = "SELECT * FROM `services` WHERE `Service_id` = $id";
                                    $service_name = mysql_query($service_name_query);

                                    while ($row = mysql_fetch_array($service_name)) {
                                      echo "<p class='lead'>";
                                      echo "Your Are Subscribed in ".$row['Description'] . "<br>";
                                      echo "</p>";
                                    }

                      				    }


                      				}
                      				


                      				?>
                      			</div>


                      		</fieldset>
                      	</form>


                      </div>

<?php
include 'includes/dash_footer.php';
?>
