Help!

[brokenreality]

Help!!! I've come up with this, and cannot seem to avoid the following error when uploading the php file "Parse error: parse error, unexpected T_VARIABLE in true_search.php on line 9"

Line 9 shows up as " $limit="10"; "

Code:

<?php

$var = @$_GET['q'] ;
$trimmed = trim($var)

$limit="10";

if ($trimmed == "")
{
echo "<p>Please enter a search...</p>";
exit;
}

if (!isset($var))
{
echo "<p>We dont seem to have a search parameter!</p>";
exit;
}

mysql_connect("","","***");

mysql_select_db("***") or die("Unable to select database");

$query = "select from Products where like \"%$trimmed%\"

order by 1st_field";

$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);

if ($numrows == 0)
{
echo "<h4>Results</h4>";
echo "<p>Sorry, your search: &quot;" . $trimmed . "&quot; returned zero results</p>";

echo "<p><a href=\"http://www.google.com/search?q="
. $trimmed . "\" target=\"_blank\" title=\"Look up
" . $trimmed . " on Google\">Click here</a> to try the
search on google</p>";
}

if (empty($s)) {
$s=0;
}

$query .= " limit $s,$limit";
$result = mysql_query($query) or die("Couldn't execute query");

echo "<p>You searched for: &quot;" . $var . "&quot;</p>";

echo "Results";
$count = 1 + $s ;

while ($row= mysql_fetch_array($result)) {
$title = $row["1st_field"];

echo "$count.)&nbsp;$title" ;
$count++ ;
}

$currPage = (($s/$limit) + 1);

echo "<br />";

if ($s>=1) {
$prevs=($s-$limit);
print "&nbsp;<a href=\"$PHP_SELF?s=$prevs&q=$var\">&lt;&lt;
Prev 10</a>&nbsp&nbsp;";
}

$pages=intval($numrows/$limit);

if ($numrows%$limit) {
$pages++;
}

if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {

$news=$s+$limit;

echo "&nbsp;<a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 &gt;&gt;</a>";
}

$a = $s + ($limit) ;
if ($a > $numrows) { $a = $numrows ; }
$b = $s + 1 ;
echo "<p>Showing results $b to $a of $numrows</p>";

?>

[stewartship]

Hi
A little confused in what u need but if line 9 is written as:

Line 9 shows up as " $limit="10"; "

then it is wrong.

if you want it as a number just do it as:

$limit = 10;

as a string

$limit = '10';

if this is not what uneeded post me back with a confirmation of what you need!

[brokenreality]

Im using this code for a mysql search. a search box grabs results from a form and displays it all on a page. still having the same problem though.

[stewartship]

first off noticed the following in code:

.....

$var = @$_GET['q'] ;

$trimmed = trim($var)

$limit="10";

.....

you need a ; after the trim($var), this might cause problems, correct this and see what happens and post me back if still trouble

[Houdini]

put a semi colon after $trimmed = trim($var);
see the red one I added, that is why the other failed. Now try the script.

[brokenreality]

I always forget those, thank you. now the the problem im running into is when i use the search box, all I get is a "Please enter a search..." dialog from the script. I had figured this would be easier, help is appreciated, thank you again

[stewartship]

hmm...

my first advise would be to use old faithful echo!

echo $var;

and

echo $trimmed;

check entries are posting through properly.....

as it appears $trimmed always blank thus getting same message appearing.

[Houdini]

echo or print out your $trimmed variable like

$var = @$_GET['q'] ;
$trimmed = trim($var);
echo "\$trimmed =".$trimmed;

$limit="10";

[brokenreality]

That did what I wanted, thank you! Still no results from my mysql database though...

[Houdini]

try changing to single quotes and remove the escape characters.

like '%$trimmed%'

[brokenreality]

Change made, and still no luck

[stewartship]

which database query is not working? specify and then can work thorugh it!

best way is to use

if($result){
}

else{
echo 'Could not do 'query x'.<br><br>';

}

this will give you the query that is causing the problem

[Houdini]

You are asking to look for data that has whatever $trimmed is in between more data, you might try it by removing one wild card first then both from either side and try the result. or go to phpMyAdmin and try the query alone with known values substitued with and without the wild cards then adjust your script.

[brokenreality]

I fixed the query, missed a letter, but it works now! thank you!