-
Notifications
You must be signed in to change notification settings - Fork 0
/
roadprobfromad.php
35 lines (29 loc) · 1.25 KB
/
roadprobfromad.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
<?php
session_start();
error_reporting(1);
$con = mysql_connect("localhost","root","","panchayat_admin");
mysql_select_db("panchayat_admin",$con);
$selectquery = mysql_query("select * from dummy where issue='Roads and Transportation'");
?>
<form method="post">
<?php
echo "<body bgcolor = '#B2B8FF'>";
echo "<br/><br/>";
echo "<table bgcolor='#B2B8FF' width='900' cellspacing='2' cellpadding='10' border='0' height='80' align='center'>";
echo "<div align='center'>";
echo "</div>";
echo "<th><center><u> Full Name </u></th><th><center> <u>Email id </u></th> <th><center><u>Telephone </u></th> <th><center><u> Issue </u></th> <th><center> <u>Comments </u></th><th><center> <u>Status </u></th>";
while($row = mysql_fetch_array($selectquery))
{
$comments = $row['comments'];
$id = $row['dissueno'];
echo "<tr>";
echo "<td align='center'>".$row['fullname']."</td>";
echo "<td align='center'>".$row['emailid']."</td>";
echo "<td align='center'>".$row['telephoneno']."</td>";
echo "<td align='center'>".$row['issue']."</td>";
echo "<td align='center'>".$row['comments']."</td>";
echo "<td align='center'><a href='roadstransportstatupdatemem.php?comments=$comments' style='text-decoration:none'>click to Answer</a></td>";
}
echo $status;
?>