Error Help

[studiobanks]

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in list.php on line 10

is an error I get when I run this script. I am trying to do a simply row color alternating table with my sql results. Why am I getting this error?

<?php

// Begin your table outside of the array
echo"<table width=550 border=0 cellpadding=4 cellspacing=0>
<tr>
__<td><b>ID</b></td>
__<td><b>NAME</b></td>
<td><b>STYLE</b></td>
<td><b>STATE</b></td>
<td><b>CITY</b></td>
_</tr>";

// Define your colors for the alternating rows

$color1="#CCFFCC";
$color2="#BFD8BC";
$row_count=0;

//connect to the database
$connection = mysql_connect("localhost", "username", "password")
or die ("could not connect to the database");

//select the database
$db = mysql_select_db("database", $connection)
or die ("could not select the database");

// Defines the sql statement which adds the record to the table
$sql_statement = "SELECT * FROM VENUES";

//excute SQL query ad get results
$sql_results = mysql_query($sql_statement, $connection)
or die ("could not exectue a query of the database");

// We are going to use the "$row" method for this query. This is just my preference.

while($row=mysql_fetch_array($sql_results)){
_$venue_id=$row["VENUE_ID"];
$name=$row["NAME"];
$style=$row["STYLE"];
$state=$row["STATE"];
__$city=_$row["CITY"];

_/ Now we do this small line which is basically going to tell
_PHP to alternate the colors between the two colors we defined above. /

___$row_color=($row_count%2)?$color1:_$color2;

____// Echo your table row and table data that you want to be looped over and over here.

_echo"<tr bgcolor="$row_color">
<td>
$venue_id</td>
<td>
$name</td>
<td>
$style</td>
<td>
$state</td>
<td>
$city</td>
__</tr>";

____// Add 1 to the row count

____$row_count++;
}

// Close out your table.

echo_"</table>";

[eoghain]

What is line 10 in your script? Also when you post code you should use the php tags so that it is formatted properly and color coded.

[studiobanks]

<td><b>CITY</b></td> 

is line 10.

[studiobanks]

Here is the code again.

<?php

// Begin your table outside of the array 
echo_"<table width=550 border=0 cellpadding=4 cellspacing=0> 
____<tr> 
________<td><b>ID</b></td> 
________<td><b>NAME</b></td> 
		<td><b>STYLE</b></td> 
		<td><b>STATE</b></td> 
		<td><b>CITY</b></td> 
____</tr>"; 

// Define your colors for the alternating rows 

$color1_=_"#CCFFCC";_ 
$color2_=_"#BFD8BC";_ 
$row_count_=_0; 

//connect to the database
$connection = mysql_connect("localhost", "bei", "harvey") 
              or die ("could not connect to the database");

//select the database
$db = mysql_select_db("berkshiresinc_com", $connection)
	  or die ("could not select the database");

// Defines the sql statement which adds the record to the table
$sql_statement = "SELECT * FROM VENUES";

//excute SQL query ad get results
$sql_results = mysql_query($sql_statement, $connection)
				or die ("could not exectue a query of the database");

// We are going to use the "$row" method for this query. This is just my preference. 

while_($row_=_mysql_fetch_array($sql_results))_{ 
____$venue_id_=_$row["VENUE_ID"]; 
____$name_=_$row["NAME"]; 
____$style_=_$row["STYLE"]; 
____$state_=_$row["STATE"]; 
____$city_=_$row["CITY"]; 

____/* Now we do this small line which is basically going to tell 
____PHP to alternate the colors between the two colors we defined above. */ 

____$row_color_=_($row_count_%_2)_?_$color1_:_$color2; 

____// Echo your table row and table data that you want to be looped over and over here. 

____echo_"<tr bgcolor="$row_color"> 
____<td> 
____$venue_id</td> 
____<td> 
____$name</td> 
____<td> 
____$style</td> 
____<td> 
____$state</td> 
____<td> 
____$city</td> 
____</tr>"; 

____// Add 1 to the row count 

____$row_count++; 
} 

// Close out your table. 

echo_"</table>";

[kinadian]

Ok, first I'm going to assume that those underscores aren't there in your actual script, they are just there for whatever reason when you copied out the code.

I'm not sure if this will fix your problem or not, but I did see this :

echo "<tr bgcolor="$row_color">

you'll need to escape the quots for the bgcolor attribute thusly:

echo "<tr bgcolor=\"$row_color\">

then continute on with your echo statement.

--kinadian

[eoghain]

Well everything there looks good. Have you tried removing that echo from the code and seeing if it runs? I've run into mysterious issues like this that were fixed by removing the offending line and re-writting it. Possibly there is some control character in there that isn't being displayed but is causing the crash.

[studiobanks]

OK I fixed the <tr bgcolor="$row_color"> to escape the ". I also removed the echo that included line ten. Below is the modified script. This is the error that I'm now getting.

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/bei/berkshiresinc-www/admin/venues/list.php on line 3

Line 3 is:
// Define your colors for the alternating rows

???????

<?php

// Define your colors for the alternating rows 

$color1_=_"#CCFFCC";_ 
$color2_=_"#BFD8BC";_ 
$row_count_=_0; 

//connect to the database
$connection = mysql_connect("localhost", "username", "password") 
              or die ("could not connect to the database");

//select the database
$db = mysql_select_db("database", $connection)
	  or die ("could not select the database");

// Defines the sql statement which adds the record to the table
$sql_statement = "SELECT * FROM VENUES";

//excute SQL query ad get results
$sql_results = mysql_query($sql_statement, $connection)
				or die ("could not exectue a query of the database");

// We are going to use the "$row" method for this query. This is just my preference. 

while_($row_=_mysql_fetch_array($sql_results))_{ 
____$venue_id_=_$row["VENUE_ID"]; 
____$name_=_$row["NAME"]; 
____$style_=_$row["STYLE"]; 
____$state_=_$row["STATE"]; 
____$city_=_$row["CITY"]; 

____/* Now we do this small line which is basically going to tell 
____PHP to alternate the colors between the two colors we defined above. */ 

____$row_color_=_($row_count_%_2)_?_$color1_:_$color2; 

____// Echo your table row and table data that you want to be looped over and over here. 

____echo_"<tr bgcolor=\"$row_color\"> 
____<td> 
____$venue_id</td> 
____<td> 
____$name</td> 
____<td> 
____$style</td> 
____<td> 
____$state</td> 
____<td> 
____$city</td> 
____</tr>"; 

____// Add 1 to the row count 

____$row_count++; 
} 

// Close out your table. 

echo_"</table>";

[eoghain]

Is this code used as an include? If so you problem might be before the include statement.

[studiobanks]

NO. I will be on the page asked for. ???

[kinadian]

Actually line 3 is:

$color1="#CCFFCC";_

Remeber, PHP, like most modern programming languages, ignore "whitespace" in a lot of areas. Try escaping out the # in your color strings. That may be your problem.

--kinadian