i written this code and i have error this code to retrieve my data from

**phpmagesh** · Dec 7 '11, 11:41 PM

everything looks good!

you may need to add this for sure $db_name and need to select dbname which you have for your application.

Code:

$dbname = "sss";
  $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$db_name = mysql_select_db('dbname', $conn);
 $result = mysql_query("SELECT * FROM V")

**johny10151981** · Dec 8 '11, 03:16 AM

Your code is not showing the error you are talking about. check your file encoding. It can make the problem and

as phpmagesh suggested you will have to select database before you run select query

**Ammu** · Dec 8 '11, 10:34 AM

Code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>participator profile</title>
<link rel="stylesheet" type="text/css" href="style.css">
<link href="Stylle.css" rel="stylesheet" type="text/css" />
</head>
<body>
 <div id ="logo">
<!----- insert logo below ------------------------------------------>
<img src="img/sss.jpg"  height="123" width="100%" border="0" alt="">
<!------------------------------------------------------------------>
</div>
<div>  </div>
<div>  </div>
<div>  </div>
<div>  </div>
<div>  </div>
 <div id = "nav">
<!----- menu, insert links below ------------------------------------------>
<div id="menu4">
<ul id="menulist1">
<li><a href="home.html">home</a></li>
<li><a href=" ">upload research </a></li>
<li><a href=" ">view symposium schedule</a></li>
<li><a href=" ">log out</a></li>
</ul>
</div>
<!-------------------------------------------------------------------------->
</div>
<div id = "container">
<div id="content">
<td width="100%">
<div class="P">
<p> 
<font size="5" color="#1c436c">&nbsp;&nbsp;&nbsp;&nbsp; Schedule for Presentions </font>
</div>
</p>
</br>
<div class="Sc">
<table border="1" cellpadding="2" cellspacing="2" width="100%">
<?php
  $conn = mysql_connect("localhost","root","password");
mysql_select_db("databasename", $conn);
 $result = mysql_query("SELECT * FROM V")
or die(mysql_error());  
echo "<table border='1'>";
echo "<tr> <th>Date</th> <th>Time</th><th>Research Title</th><th>Judge Name</th><th>Judge ID</th><th>Room</th> </tr> ";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result ))
 {
    // Print out the contents of each row into a table
    echo "<tr><td>"; 
    echo $row['Data'];
    echo "</td><td>"; 
    echo $row['Time'];
    echo "</td><td>"; 
    echo $row['ResearchTitle'];
    echo "</td><td>";
    echo $row['JudgeName'];
    echo "</td><td>";
    echo $row['JudgeID'];
    echo "</td><td>";
    echo $row['Room'];
    echo "</td></tr>";
}
echo "</table>";
mysql_close($conn);
?>
</body>
</html>

i written this code and i have error this code to retrieve my data from

i written this code and i have error this code to retrieve my data from

Comment

Comment

Comment