Problem with query in php mysql?

hi,
this is a mysql query shows the rows of table pharmacy with columns id,Code,Name ,Exp (the drug expiry date)and ExpLeft (Expiray Left for the drugs in months) for the drugs, the query is working fine without (WHERE ExpLeft='$ExpLef'), i want to query for the column ExpLeft for exmple for the drugs EcpLeft is 12 months, the code is not working with the query WHERE , there is no any error in ouput just shows the table headers.

<html>
<head>
<title>Open Pharmacy</title>
<style type="text/css">
table tr td { font: 12px Verdana, Arial, sans-serif;
text-align: center;
font-weight: bold;
}
table tr th { font-size: 12px;
text-align: center;
}
</style>
</head>

<body>

<?php
include 'library/config.php';
include 'library/opendb.php';
include 'library/paging_function.php';
$ExpLef = $_POST['EexpLef'];
// query the table
$result = mysql_query("SELECT count(*) FROM pharmacy");
$total = mysql_result($result, 0);
$news = mysql_query("SELECT * FROM pharmacy WHERE ExpLeft='ExpLef' ORDER BY id ASC LIMIT $start, $display");
echo "<table border='1'>";
echo "<tr><th>Id</th><th>Code</th><th>Name</th><th>ExpLeft</th></tr>";
while($row = mysql_fetch_assoc($news)) {
// Expiray Left in Months
$Exp = $row[Exp];
$expires=strtotime($Exp);
$rightnow=time();
$secondsleft=$expires-$rightnow;
$ExpLeft=round($secondsleft/2592000);

echo "<tr><td>";
echo $row[id];
echo "</td><td>";
echo $row[Code];
echo "</td><td>";
echo $row[Name];
echo "</td><td>";
echo $ExpLeft;
echo "</td></tr>";
}
echo "</table>";
paginate($display, $pg, $total);
include 'library/closedb.php';
?>
</body>
</html>

Problem with query in php mysql?

shams

supermanjnk

shams

mcibor

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week