<form id="form1" name="form1" method="post" action="<? echo $PHP_SELF; ?> "> <input type="submit" name="submit" id="submit" value="submit" /> <?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db('import',$con) or die('could not select database') ; $res=mysql_query("SELECT date FROM temp1 GROUP BY date HAVING COUNT(*)>1"); echo "<select name='select'> <option value=''>--- Select ---</option> "; while($row=mysql_fetch_assoc($res)) { echo "<option value=$row[date]>$row[date]</a></option>"; } echo "</select>"; echo "</form>"; $result=mysql_query("SELECT id,date,mobno,state,type,telecaller FROM temp1 WHERE date='$select' ") or die(mysql_error()); "</form>"; echo"<table>"; echo"<tr> <th>id</th><th>date</th><th>mobno</th><th>state</th><th>type</th><th>telecaller</th>"; while($row=mysql_fetch_array($result)) { echo"<tr><td>"; echo $row['id']; echo"<tr><td>"; echo $row['date']; echo"<tr><td>"; echo $row['mobno']; echo"<tr><td>"; echo $row['state']; echo"<tr><td>"; echo $row['type']; echo"<tr><td>"; echo $row['telecaller']; } echo"</table>"; ?>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)