<?php 
include_once("session.php");
include_once("settings.php");
include_once("functions.php");
if($_REQUEST['action'] == 'deletedistributors'){
    $sql = "delete from tblDistributors where id = '".$_REQUEST['id']."'";
    mysql_query($sql) or die(mysql_error()); 
}


?> 
<LINK href="mel.css" type=text/css rel=stylesheet>
<LINK href="sdmenu.css" type=text/css rel=stylesheet>
<table width="94%" border="0" cellspacing="0" cellpadding="0">
	<tr> 
		<td>
			<fieldset>
				<legend>Distributors List</legend>
				<table width="100%" border="0" cellspacing="2" cellpadding="0">
				<?php
					if($msg!=""){ ?>
					<tr valign="middle" class="general"> 
						<td height="26" colspan="6"> 
							<?=$msg;?>
						</td>
					</tr>
				<?php } ?>
					<tr valign="middle" class="general"> 
						<td width="10%" height="26">Name</td>
						<td width="10%" height="26" >Address</td>
						<td width="10%" height="26" >City</td>
						<td width="10%" height="26">Mobile No.</td>
						<td width="10%" height="26">Location</td>
						<td width="8%" align="center" >Action</td>
					</tr> 	
				<?php
					$query	= "select * from `tblDistributors` order by createdOn DESC";
					$result	= mysql_query($query) or die (mysql_error());
					while($row=mysql_fetch_assoc($result)){
				?>
					<tr valign="top" class="generaltxt">  	 	 	 	 	
						<td height='24'><?php echo substr(stripslashes($row["name"]),0,10);?></td>
						<td><?php echo substr(stripslashes($row["address"]),0,10);?></td>
						<td><?php echo substr(stripslashes($row["city"]),0,10);?></td>
						<td><?php echo substr(stripslashes($row["mobile"]),0,10);?></td>
						<td><?php echo substr(stripslashes($row["location"]),0,10);?></td>
                                           
						<td align="center"><a  href="distributors_list.php?id=<?php echo $row['id']; ?>&action=deletedistributors" onClick="return confirm('Are you sure you want to delete this info')" class="action1">Delete</a></td>
					</tr>
				<?php } ?>
				</table>
			</fieldset>
		</td>
	</tr>
</table>