[Resolved] What does this error mean

adi5402

i am trying to run two sql querys on a page with a pipe in one of them For some reason i keep getting this pass error. I dont know what it means the error is

[ERROR]
Parse error: parse error, unexpected $end in C:\apachefriends\xampp\webalizer\Gbooks\subs\bodySub.php on line 102
[ERROR]

My Code looks like this

<table>

<?php 
$sub = $myMod;
$sql = 'SELECT `module` , `subject` , `relation` , `relation_link` , `add_SubCat` , `intro` , `teaser` , `discription` '
        . ' FROM `subjet_catogories` '
        . ' WHERE`module` = "'.$sub.'" LIMIT 0, 30'; 
		  $result = mysql_query($sql) or die(mysql_error());

	  while($row = mysql_fetch_array($result)) {
	 $tempSub =  $row['subject'];
		$tempImg=$row['add_SubCat'];
		$tempMod = $row['module'];



?>
	<tr ="leftTR">
		<td> <img src="../Images/adds/sub/<?php echo $tempImg;  ?>.gif" alt="subject Image" /></td>
		<td><?php echo $tempSub; ?></td>
		<td></td>
		<?php } // top while loop closed?>
	</tr>

<tr class="CenterTR">
					<td>      
<?php


$MySql = 'SELECT * '
        . ' FROM `products` '
        . ' WHERE `module` '
        . ' LIKE \'Web Technologies\' LIMIT 0, 30'; 

					$results= mysql_query($MySql) or die(mysql_error());

					while($row =mysql_fetch_array($results)) 
					{
						$product_id =$row['product_id'];
						$book_title = $row['title'];
						$book_author = $row['author'];
						$book_publisher =$row['publisher'];
						$book_subject = $row['subject'];
						$book_price = $row['price'];
						$_ava = $row['available'];
						$book_ISBN = $row['isbn'];	
						$book_img = $row['img'];
						$book_rating = $row['rating'];
						$ava_Stock = $row['in_stock'];	
						$book_link = $row['html'];


						$Sresults .=<<<RUS

					<table width="100%">
					<tr>
					<td width="70%">
					<h1 id="book_title">$book_title</h1>
					<h3>by  $book_author</h3>
					<h3>Published by: $book_publisher </h3>
					<h3>Subject Category: $book_subject </h3>
					<div id="priceleft"><b>Price: £ $book_price <b></div></br>
					<b>Available: $_ava</b> </br>
					 <div id="priceleft"><b>in Stock: $ava_Stock<b></div></br>
						<emp>ISBN: $book_ISBN</emp>  
						<div id="priceleft"> 
							<a href="cart/add-to-cart.php?$product_id" class="des">
								<img src="/Images/buttons/button-addtobasket-small.gif" alt="Add to basket" class="cartbuttons" />
							</a></br>
						</div>
					<div id="priceleft">
					<b>Quality Rating: </b>
					RUS;

							for($i=0; $i< $book_rating; $i++) 
						{
						$Sresults .= "<img src='Images/Stars/star2.gif' alt='rating' />"; 
						}

					$Sresults .= "</div>";



					$Sresults .= "<hr width='80%' >";
					$Sresults .= "</td>";
					$Sresults .= "<td><a href='subs/books/$book_link'><img src='/Images/Books/$book_img' alt='$book_publisher' height='200' width='150'/></a> </br>";
					$Sresults .= "<a href='subs/books/$book_link' class='des'> See Full description </a></td></tr><tr><td></td></tr></table>";

					}

					print $Sresults;
			?>
			</td>
	<td></td>
	<td></td>
</tr>
<tr class="RightTr">
	<td></td>
	<td></td>
	<td></td>
</tr>
</table>

Any body see the problem

LordShryku

You're missing the closing brace } from your first while statement. That error usually means you missed a closing brace somewhere.

adi5402

I first though it could be atleast i know what the error is pointing to but i think i closed it maybe i need to stick the top stuff in a pipe varible i will try that now

adi5402

I stuck it in a Pipe and now im getting some new error which I still dont know about can u see anything wrong in this code or the origional. that i can use to fix this problem

new error is
Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\apachefriends\xampp\webalizer\Gbooks\subs\bodySub.php on line 52

code with some changes


<table>
<tr ="leftTR">
		<!--<td> <img src="../Images/adds/sub/<php echo $tempImg;  ?>.gif" alt="subject Image" /></td>
		<td><php echo $tempSub; ?></td>
-->		
<td>
<?php 
$sub = $myMod;
$sql = 'SELECT `module` , `subject` , `relation` , `relation_link` , `add_SubCat` , `intro` , `teaser` , `discription` '
        . ' FROM `subjet_catogories` '
        . ' WHERE`module` = "'.$sub.'" LIMIT 0, 30'; 
		  $result = mysql_query($sql) or die(mysql_error());

	  while($row = mysql_fetch_array($result)){
	 $tempSub =  $row['subject'];
		$tempImg=$row['add_SubCat'];
		$tempMod = $row['module'];


		$myPipe .=<<<PIP
		<table width="100%">
					<tr>
						<td width="100%">
							 $tempMod;
						</td>
					</tr>
		</table>
		PIP;
		}
		print $myPipe;

		// End of top section

?>
</td>

</tr>

<tr class="CenterTR">
		<td>      
<?php


$search = 'SELECT * '
        . ' FROM `products` '
        . ' WHERE `module` '
        . ' LIKE \'Web Technologies\' LIMIT 0, 30'; 

					$results= mysql_query($search) or die(mysql_error());

					while($row =mysql_fetch_array($results)){
						$product_id=$row['product_id'];
						$book_title=$row['title'];
						$book_author=$row['author'];
						$book_publisher =$row['publisher'];
						$book_subject = $row['subject'];
						$book_price = $row['price'];
						$_ava = $row['available'];
						$book_ISBN = $row['isbn'];	
						$book_img = $row['img'];
						$book_rating = $row['rating'];
						$ava_Stock = $row['in_stock'];	
						$book_link = $row['html'];


						$Sresults .=<<<RUS

					<table width="100%">
					<tr>
					<td width="70%">
					<h1 id="book_title">$book_title</h1>
					<h3>by  $book_author</h3>
					<h3>Published by: $book_publisher </h3>
					<h3>Subject Category: $book_subject </h3>
					<div id="priceleft"><b>Price: £ $book_price <b></div></br>
					<b>Available: $_ava</b> </br>
					 <div id="priceleft"><b>in Stock: $ava_Stock<b></div></br>
						<emp>ISBN: $book_ISBN</emp>  
						<div id="priceleft"> 
							<a href="cart/add-to-cart.php?$product_id" class="des">
								<img src="/Images/buttons/button-addtobasket-small.gif" alt="Add to basket" class="cartbuttons" />
							</a></br>
						</div>
					<div id="priceleft">
					<b>Quality Rating: </b>
					RUS;

										for($i=0; $i< $book_rating; $i++) 
									{
									$Sresults .= "<img src='Images/Stars/star2.gif' alt='rating' />"; 
									}

					$Sresults .= "</div>";



					$Sresults .= "<hr width='80%' >";
					$Sresults .= "</td>";
					$Sresults .= "<td><a href='subs/books/$book_link'><img src='/Images/Books/$book_img' alt='$book_publisher' height='200' width='150'/></a> </br>";
					$Sresults .= "<a href='subs/books/$book_link' class='des'> See Full description </a></td></tr><tr><td></td></tr></table>";
				}


					print $Sresults;

			?>
			</td>
	<td></td>
	<td></td>
</tr>
<tr class="RightTr">
	<td></td>
	<td></td>
	<td></td>
</tr>
</table>

tsinka

Hi,

RUS; has to be at the very beginning of the line.

Thomas

adi5402

What do you mean is it like I need to stick it to the corner of the page

tsinka

Additionally,

there mustn't be any white space at the end of the line.

$Sresults .=<<<RUS

The line must end after the S

Thomas

tsinka

Example:

Don't do e.g.:

$var .= <<< EOTXT
text text
text
text
    EOTXT;

but

$var .= <<< EOTXT
text text
text
text
EOTXT;

Make sure that the $var .= line ends with EOTXT without any trailing whitespaces.

Thomas

adi5402

Very intersting to know that fact i made sure that the lines are ending but unfortunately its not worked still comming up with the same error I checked for the PIP as well. The line the error is corresponding to is 52 which is pointing to this line

while($row =mysql_fetch_array($results)){
$product_id=$row['product_id'];
$book_title=$row['title'];

anything else

adi5402

Ya i think that last reply did the trick thanks man the origional error was in with the pipe

tsinka

There is another problem:

$search = 'SELECT * '
        . ' FROM `products` '
        . ' WHERE `module` '
        . ' LIKE 'Web Technologies' LIMIT 0, 30';

The single quotes around Web Technologies break up the string.

Change it to

$search = "SELECT * "
        . " FROM `products` "
        . " WHERE `module` "
        . " LIKE 'Web Technologies' LIMIT 0, 30";

Thomas