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

Expand|Select|Wrap|Line Numbers

 <!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

  $dbhost = "localhost";

  $dbuser = "root";

  $dbpass = "";

  $dbname = "sss";

  $conn = mysql_connect($dbhost, $dbuser, $dbpass)

  or die ('Error connecting to mysql');

 $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 have error

Parse error: syntax error, unexpected T_ECHO, expecting ',' or ';' in C:\xampp\htdocs\View.php on line 73

plz help me

Dec 7 '11 #1

Subscribe Post Reply

1229

phpmagesh

119

100+

everything looks good!

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

Expand|Select|Wrap|Line Numbers

 
$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")

Dec 7 '11 #2

johny10151981

1,059

1GB

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

Dec 8 '11 #3

Ammu

Expand|Select|Wrap|Line Numbers

 <!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>

Dec 8 '11 #4

by: Vanessa | last post by:

I have a question, is that any other way to retrieve data from another webpage besides using XML object? Because I am using XML object now but give me so much problems. If I used...

ASP / Active Server Pages

Retrieve data from an Excel spreadsheet using ADO.NET connection objects

by: funcSter | last post by:

I want to retrieve data from an Excel file like how I would with a database. I understand that I would have to use OLE DB. Somehow I think I cannot get the connection string right, as the bit of...

Visual Basic .NET

Weird behavior on page when trying to retrieve data from Session

by: Kash | last post by:

Hi everybody I have a session on my vb.net web applications first page to store an one dimensional array: dim myAry(2) As String myAry(0) = xVal myAry(1) = yVal...

.NET Framework

how to retrieve data from access using ado

by: hims | last post by:

hi i want to retrieve data from access through vb6.0 program but its not working. either sort out my error or help me with correct coding. thanks in advance !!!!!!! mail me at...

Visual Basic 4 / 5 / 6

Retrieve data from Database using struts jsp

by: lifeisgreat20009 | last post by:

I am a newbie to Struts and JSP...I have been working on the code below for 5 hours now..I googled a lot but couldn't get much help so finally I am here.. Hoping of getting my problem solved. Please...

Java

Get error when retrieve data from mysql

by: ghjk | last post by:

I want to write a php code for a login page. When I enter correct user name and password I got the error ;Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in...

PHP

Retrieve Data from Excel to fill DataGridView

by: lenniekuah | last post by:

Hi Friends, I need your help. Please help me. I am trying to retrieve data from Excel Spreadsheet to fill the DataGridView for display prior to updating SQL SERVER with individual DataGridView...

.NET Framework

How to retrieve data from oracle database to Visual Studio -2005 asp.net grid view?

by: michaelTun | last post by:

how can I retrieve data from oracle database to Visual Studio -2005 asp.net grid view. connection.Open() string sql = "select * from departments where department_id < 60" cmd = new...

Oracle Database

How to retrieve data from Oracle package using C#.net 2.0?

by: michael Tun | last post by:

How can I retrieve data from oracle package. OracleCommand command = new OracleCommand("STAFF_SELECT", connection); command.CommandType = CommandType.StoredProcedure; STAFF_SELECT is...

C# / C Sharp

C#NET2008 Retrieve Data from DataGridView

by: lenniekuah | last post by:

Hullo Good Guys, I need your help. Please help me. I am very surprise of this error message: Index was out of range. Must be non-negative and less thatnt he size of the collection. Parameter name...

C# / C Sharp

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

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

Similar topics