Menu
hello every one ,,,, thanks for the help that u guys did before .. but here anain i’m stuck with new idea…… i need some help from u guy … i have written a script to display data from sql table which is working perfectly fine and my new idea is to put a scroll bar so that it look good and the data wont overflow to down …. can any one check the code and tell whether i can do or not …and is there any way of doing it …. i really want to impress my boss…
here is the code-
<!DOCTYPE HTML PUBLIC “-//W3C//DTD HTML 4.01 Transitional//EN” “
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv=”Content-Type” content=”text/html; charset=iso-8859-1″>
</head>
<body>
<form action=”” method=”post” >
<p> </p>
<table bgcolor=”#313131″ width=”620″cellpadding=”30″ cellspacing=”0″ border=”0″ height=”” align=”center”>
<tr>
<td align=”left” colspan=”2″>
<font color=”#FFFFFF” size=”6″> Enter Date:</font>
<input type=”text” name=”eventdate” size=”10″/><font color=”#FFFFFF” size=”3″>*Date Format MM/DD/YYYY
</td></tr>
<tr>
<td align=”right”><input name=”submit” style=”font-size:12pt “type=”submit” value=”submit”/>
</td></tr>
</table>
</form>
<?php
include(“connect.php”);
include(“userinfo.php”);
if($_POST[‘submit’]==”submit”) {
$query =”SELECT * FROM event_list where eventdate= ‘$eventdate'”;
$result = mysql_query($query) or die (“Couldn’t query data” . mysql_error());
$eventdate = mysql_real_escape_string($_POST[‘eventdate’]);
$event = mysql_real_escape_string($
while ($row = mysql_fetch_assoc($result)) {
echo “<tr>”;
echo “<td>” . $row[‘Room_No’] . “</td>”;
echo “<td>” . $row[‘eventdate’] . “</td>”;
echo “<td>” . $row[‘event’] . “</td>”;
echo “</tr>”;
}
}
echo “</table>”;
?>
</table>
</body>
</html>