hey m making a projec in one of its page i want to get the data from the table and display it on screen in the form of table. allthough the data appears but how can i display the headings.
$num=mysql_num_rows($result);
print "<table width=600 border=1>\n";
while ($get_info = mysql_fetch_row($result))
{
print "<tr>\n";
foreach ($get_info as $field)
print "\t<td>$field</td>\n";
print "</tr>\n";
}
print "</table>\n";
mysql_close($con);
?>
Add them manually before the while loop:
print '<tr><th>Your field name here</th></tr>';each time when i tries it gives this error
syntax error, unexpected '<' inthis is my whole code
<html>
<head>
<title>Display Records</title>
</head>
<body>
<?php
$con=mysql_connect("localhost","root","");
mysql_select_db("pras2");
$query= "SELECT * FROM employee";
$result=mysql_query($query);
$num=mysql_num_rows($result);
print "<table width=600 border=1>\n";
<tr><th>id</th>
<th>name</th>
<th>password</th>
<th>rank</th>
<th>department</th>
<th>nic</th>
<th>numbr</th>
<th>adress</th>
<th>s</th></tr>
while ($get_info = mysql_fetch_row($result))
{
print "<tr>\n";
foreach ($get_info as $field)
print "\t<td>$field</td>\n";
print "</tr>\n";
}
print "</table>\n";
mysql_close($con);
?>
</body>
</html>Your print ""; 's are missing.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.