Parse error in search/results page

[acorn]

I'm developing a small inventory app for a client, using a PHP/MySql model. I have a search page with only one text field and a submit button. I want to search for data matching the string entered in the text field in ANY field in the table/recordset. I'm using Dreamweaver MX2004 to generate the code. I thought I had everything right, but here's the error I'm getting:

Parse error: parse error, unexpected '=', expecting ',' or ')' in c:\inetpub\wwwroot\licenseapp\results.php on line 12

Here are lines 10 - 13 of the code:

$varsearch_authset = "%";
if (isset(#search#)) {
$varsearch_authset = (get_magic_quotes_gpc()) ? #search# : addslashes(#search#);
}

Here's the SQL statement:

SELECT *
FROM authorization
WHERE AuthorizationID LIKE 'varsearch' OR EffectiveDate LIKE 'varsearch' OR ExpDate LIKE 'varsearch' OR AuthNumber LIKE 'varsearch' OR AuthLevel LIKE 'varsearch' OR Requirements LIKE 'varsearch' OR ContactFirst LIKE 'varsearch' OR ContactLast LIKE 'varsearch' OR ContactEmail LIKE 'varsearch' OR ContactPhone LIKE 'varsearch' OR ContactAddy LIKE 'varsearch' OR ContactSuite LIKE 'varsearch' OR ContactCity LIKE 'varsearch' OR ContactState LIKE 'varsearch' OR ContactZip LIKE 'varsearch' OR ContactCountry LIKE 'varsearch' OR Vendor LIKE 'varsearch' OR Personal LIKE 'varsearch' OR Business LIKE 'varsearch' OR Retail LIKE 'varsearch' OR Government LIKE 'varsearch' OR EduK12 LIKE 'varsearch' OR EduHigher LIKE 'varsearch'

And, in the Advanced Recordset dialogue box, I have the variable, 'varsearch' set as follows:

Name - varsearch
Default Value - %
Runtime Value - #search# (the name of the textbox on the search page)

Can anybody see what I'm doing wrong?

TIA,
acorn

[YappyDog]

Probably need to put a dollar sign ($) in front of all your #search# uses. That way it is a variable that php understands.

$varsearch_authset = "%";
if (isset(#search#)) {
$varsearch_authset = (get_magic_quotes_gpc()) ? #search# : addslashes(#search#);
}

[acorn]

Okay, I replaced all instances of #search# with $search... Should be right? However, now when i search, it returns ALL records...

$maxRows_authset = 10;
$pageNum_authset = 0;
if (isset($_GET['pageNum_authset'])) {
  $pageNum_authset = $_GET['pageNum_authset'];
}
$startRow_authset = $pageNum_authset * $maxRows_authset;

$varsearch_authset = "%";
if (isset($search)) {
  $varsearch_authset = (get_magic_quotes_gpc()) ? $search : addslashes($search);
}
mysql_select_db($database_vendorauth, $vendorauth);
$query_authset = sprintf("SELECT * FROM `authorization` WHERE AuthorizationID LIKE '%s' OR EffectiveDate LIKE '%s' OR ExpDate LIKE '%s' OR AuthNumber LIKE '%s' OR AuthLevel LIKE '%s' OR Requirements LIKE '%s' OR ContactFirst LIKE '%s' OR ContactLast LIKE '%s' OR ContactEmail LIKE '%s' OR ContactPhone LIKE '%s' OR ContactAddy LIKE '%s' OR ContactSuite LIKE '%s' OR ContactCity LIKE '%s' OR ContactState LIKE '%s' OR ContactZip LIKE '%s' OR ContactCountry LIKE '%s' OR Vendor LIKE '%s' OR Personal LIKE '%s' OR Business LIKE '%s' OR Retail LIKE '%s' OR Government LIKE '%s' OR EduK12 LIKE '%s' OR EduHigher LIKE '%s'", $varsearch_authset,$varsearch_authset,$varsearch_authset,$varsearch_authset,$varsearch_authset,$varsearch_authset,$varsearch_authset,$varsearch_authset,$varsearch_authset,$varsearch_authset,$varsearch_authset,$varsearch_authset,$varsearch_authset,$varsearch_authset,$varsearch_authset,$varsearch_authset,$varsearch_authset,$varsearch_authset,$varsearch_authset,$varsearch_authset,$varsearch_authset,$varsearch_authset,$varsearch_authset);
$query_limit_authset = sprintf("%s LIMIT %d, %d", $query_authset, $startRow_authset, $maxRows_authset);
$authset = mysql_query($query_limit_authset, $vendorauth) or die(mysql_error());
$row_authset = mysql_fetch_assoc($authset);

Uhhhh... hmmmmm.. THAT looks funny 😛

-acorn