is there any way through which we can generate reports in mysql.
not using any s/w but coding.
if yes plz tell me

you can do it in php . Here is the code i use to show a report of all the people whose email adresses and names i have in my database

<title>Test MYSQL PHP Page</title>
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM contacts";
echo "<b><u><center>Database Output</center></u></b><br>";
echo "<hr>";
while ($i < $num) {
echo "<b>$first $last</b><br>$email<br><hr><br>";
<center><a href="/index.php">Return to main page</a></center>
</html> should contain something like:


thanks for the info bro.
any way to do it in jsp?????

yes there is but thats not my speciality, sorry