simple problem but i just cant spot it-see if u can

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
chris12295
Forum Contributor
Posts: 113
Joined: Sun Jun 09, 2002 10:28 pm
Location: USA
Contact:

simple problem but i just cant spot it-see if u can

Post by chris12295 »

Code: Select all

<?




if(!isset($submit) && $submit=='go')
	&#123;
		echo "<form name='form1' action=$PHP_SELF method='post'>";
		echo "Keywords: <input type='text' name='keyword'>";
		echo "<input type='submit' name='submit' value='go'>";
	&#125;




else
	&#123;

		echo <<<EOQ
			<table cellpadding=0 cellspacing=0 border=0 width=950>
				<tr><td><img src="images/logo.gif" alt="" border="0" align="left" hspace=0 width=100></td>
		    		<td width=900><br><span style="color:#000000;font-family:arial;font-size:20pt">Boat Salvage</span><br><br></td>
				</tr>
			</table>
		EOQ;




		mysql_connect("localhost");
		mysql_select_db("Ads");




		$query = "select * from user_Ads where $searchMethod == '$keyword' limit $resultsStart,$rowsToShow";




		$results=mysql_query($query);
		$totalResults = mysql_num_rows($results);
		$totalColumns = mysql_num_fields($results);


		if($totalResults == 0)
			&#123;
				echo "Your search for <b>$keyword</b> resturned <b>0</b> results.  Please try other keyword(s).";
			&#125;

		else
			&#123;
				echo "Your search for <b>$keywords</b> returned <b>$totalResults</b> results.";
				echo <<<EOQ
					<form name=form1 action=$PHP_SELF method=post>
				      	<input type='hidden' name='resultId' value=$pageNumber*5>
				      	<input type='hidden' name='pageNumber' value=$page>
                                      	<input type='hidden' name='submit' value='go'>
                                      	<input type='hidden' name='searchMethod' value=$searchMethod>
                                      	<input type='hidden' name='rowsToShow' value=$rowsToShow>
                                      	<input type='hidden' name='keyword' value=$keyword>
					<input type='hidden' name='resultsStart' value=$resultsStart>
					</form>
                                      	<a href='index.html'>New Search</a><br><br>
				     EOQ;

				if($totalResults > 0 && $totalResults - ($pageNumber * 5) > 0 && $pageNumber != 1)



					&#123;
						


						echo "<a href='search2.php?resultId=";
						echo $pageNumber*5;
						echo "&pageNumber=";
						echo $pageNumber-1;
						echo "&submit=go&searchMethod=$searchMethod&rowsToShow=5&keyword=$keyword&resultsStart=";
						echo $resultsStart-5;
						echo "'><--Prev</a> ";

						for($i=0;$i<$totalResults/5;$i++)
							&#123;
								echo "<a href='search2.php?resultId=";
								echo $pageNumber*5;
								echo "&pageNumber=$i&submit=go&searchMethod=$searchMethod&rowsToShow=5&keyword=$keyword&resultsStart=";
								echo $i*5;
								echo "'>$i</a> ";
							&#125;

                               			 echo "<a href='javascript:document.form1.submit()'>Next--></a><br>";	





					&#125;

		elseif($num_results>=1 && $num_results - ($page*5) <= 0) 
			&#123;

				echo "<a href='search2.php?resultId=";
						echo $pageNumber*5;
						echo "&pageNumber=";
						echo $pageNumber-1;
						echo "&submit=go&searchMethod=$searchMethod&rowsToShow=5&keyword=$keyword&resultsStart=";
						echo $resultsStart-5;
						echo "'><--Prev</a> ";


				for($i=0;$i<$totalResults/5;$i++)
					&#123;
						echo "<a href='search2.php?resultId=";
						echo $pageNumber*5;
						echo "&pageNumber=$i&submit=go&searchMethod=$searchMethod&rowsToShow=5&keyword=$keyword&resultsStart=";
						echo $i*5;
						echo "'>$i</a> ";
					&#125;
			&#125;

		else
			&#123;
				for($i=0;$i<$totalResults/5;$i++)
					&#123;
						echo "<a href='search2.php?resultId=";
						echo $pageNumber*5;
						echo "&pageNumber=$i&submit=go&searchMethod=$searchMethod&rowsToShow=5&keyword=$keyword&resultsStart=";
						echo $i*5;
						echo "'>$i</a> ";
					&#125;
				echo "<a href='javascript:document.form1.submit()'>Next--></a>\n</form>\n";
			&#125;

		&#125;


		while ($row = mysql_fetch_row($result)) 
			&#123;
				$resultCount += 1;
				echo "<table border=0 width=900 cellpadding=0 cellspacing=0>\n";

					
						echo "<tr><td bgcolor='#004080'><center><span style='color:#ffffff;width:100%'><b>Part:</b>$row&#1111;7] $row&#1111;9] $row&#1111;8]--><b>Category:</b> $row&#1111;6]</span></center></td></tr>";
						echo "<tr bgcolor=#e1e1e1>\n";
						echo "<td>";
						echo "<b>$resultCount</b>. $row&#1111;2], $row&#1111;1]<blockquote>$row&#1111;10]<br><b>E-mail:</b> <a href='mailto:$row&#1111;3]'>$row&#1111;3]</a><br><b>Phone:</b> $row&#1111;4] <b>Fax:</b> $row&#1111;5]<br>";
						$i = 11;
						echo "</td>\n";
						echo "</tr>\n";

				echo "</table>";
				echo "<br><br>";
			&#125;




	
	&#125;

?>
It says there is a parse error on line 164 but i think my error is somwhere else in the code.
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Not sure why, maybe someone else can say (I'm too tired to work it out) but this works:

Code: Select all

$html =<<<EOQ
<table cellpadding=0 cellspacing=0 border=0 width=950> 
<tr><td><img src="images/logo.gif" alt="" border="0" align="left" hspace=0 width=100></td> 
<td width=900><br><span style="color:#000000;font-family:arial;font-size:20pt">Boat Salvage</span><br><br></td> 
</tr> 
</table> 
EOQ;
echo $html;

// AND

$html =<<<EOQ
<form name=form1 action=$PHP_SELF method=post> 
<input type='hidden' name='resultId' value=$pageNumber*5> 
<input type='hidden' name='pageNumber' value=$page> 
<input type='hidden' name='submit' value='go'> 
<input type='hidden' name='searchMethod' value=$searchMethod> 
<input type='hidden' name='rowsToShow' value=$rowsToShow> 
<input type='hidden' name='keyword' value=$keyword> 
<input type='hidden' name='resultsStart' value=$resultsStart> 
</form> 
<a href='index.html'>New Search</a><br><br> 
EOQ;
echo $html;
Weird. BTW, by works I mean I don't get any parse errors using the above, obviously I don't have your database to test on to check that nothing else is going screwy.

Mac

PS. You need to remove the space after <<<EOQ
Zmodem
Forum Commoner
Posts: 84
Joined: Thu Apr 18, 2002 3:59 pm

Post by Zmodem »

So what seems to be the problem? Are you getting an error message or is it just not working the way it should.

more info please ;)
Post Reply