Parse Error Help...urgent

bg21486

Thanks for helping me on a woeekdn!

Here is the code i am trying to run. however i am getting:

Parse error: parse error, expecting ','' or';'' in c:\apache\htdocs\aol\adv_course.php on line 168

here is the code:

<?
// set a variable with the database name
$database_name = "test";

// attempt to connect ot database and store result in a variable
$dbh = mysql_connect("localhost","root","");

// check the result of the connection attempt
if (!mysql_select_db($database_name)) {
echo "Can't Select $database_name";
}

// execute a query and store the result
$res = mysql_query("select StartDate,EndDate,courseId,City,CourseType,TeacherId1,CoEmail,CoordinatorId,CoodPhone from coursetable where courseName = 'Advanced' ",$dbh);

// check to make sure the query actually ran
if (!$res) {
echo mysql_errno().": ". mysql_error ()."";
return 0;
}

if(mysql_num_rows($res) == 0)
echo("Nothing to Display!");

// use the query results
while ($thearray = mysql_fetch_array($res)) {
(line 168) -> echo "<tr valign="middle" class =courses1>";
echo "<td align="center">$thearray['StartDate']- $thearray['EndDate']</td>";
echo "<td align="center"><a href="http://localhost/AOL/login.php?id=$thearray['courseId']">$thearray'City'</a></td>";
echo "<td align="center">$thearray['TeacherId1']</td>";
echo "<td align="center"><a href="mailto:$thearray['CoEmail']">$thearray['CoordinatorId']</a> $thearray['CoodPhone']</td></tr>";
}
?>

rohithmr

Please enclose ur code in

 tags, so the color coding will make it about 700 times easier to track the error. And it would be also helpful if you could tell us which is line 168

jpmoriarty

hold on a tic:

<? 
// set a variable with the database name 
$database_name = "test"; 

// attempt to connect ot database and store result in a variable 
$dbh = mysql_connect("localhost","root",""); 

// check the result of the connection attempt 
if (!mysql_select_db($database_name)) { 
echo "Can't Select $database_name"; 
} 

// execute a query and store the result 
$res = mysql_query("select StartDate,EndDate,courseId,City,CourseType,Teacher
Id1,CoEmail,CoordinatorId,CoodPhone from coursetable where courseName = 'Advanced' ",$dbh); 

// check to make sure the query actually ran 
if (!$res) { 
echo mysql_errno().": ". mysql_error ().""; 
return 0; 
} 

if(mysql_num_rows($res) == 0) 
echo("Nothing to Display!"); 



// use the query results 
while ($thearray = mysql_fetch_array($res)) { 
(line 168) -> echo "<tr valign="middle" class =courses1>"; 
echo "<td align="center"><FONT SIZE="1" FACE="Arial, Helvetica, sans-serif">$thearray['StartDate']- $thearray['EndDate']</font></td>"; 
echo "<td align="center"><FONT SIZE="1" FACE="Arial, Helvetica, sans-serif"><a href="http://localhost/AOL/login.php?id=$thearray['courseId']">$thearray['City']($thearray['CourseType'])</a></font></td>"; 
echo "<td align="center"><FONT SIZE="1" FACE="Arial, Helvetica, sans-serif">$thearray['TeacherId1']</font></td>"; 
echo "<td align="center"><FONT SIZE="1" FACE="Arial, Helvetica, sans-serif"><a href="mailto:$thearray['CoEmail']">$thearray['CoordinatorId']</a><br>$thearray['CoodPhone']</font></td></tr>"; 
} 
?>

jpmoriarty

your problem is at the end: you cant use double quotes inside a quote without escaping them first. You also should break out of the echo when you're trying to access arrays, comme ca:

echo "<td align=\"center\"><FONT SIZE=\"1\" FACE=\"Arial, Helvetica, sans-serif\">".($thearray['StartDate']- $thearray['EndDate'])."</font></td>";

etc etc

jpmoriarty

ah, so urgent that you wasted my time by double posting.

Many thanks