Syntax problem

baffled_in_UK

Hi,

I'm expanding a search feature on my site to include a variety of different field combinations.

My current simple db selection looks like this

$result = mysql_query("SELECT *  FROM clubs WHERE checked = 'Y' AND $a LIKE '%$b%' ORDER BY $a LIMIT $offset,10",$db)

and this works fine.
What I'm trying to do now is build the select string depending on the values selected, such as this

if ($i == "1") {
$sqlsearch1="mysql_query(\"SELECT *  FROM clubs WHERE checked = 'Y' AND $a LIKE '%$b%' ORDER BY $a LIMIT $offset,10\",$db)";  }

I then use this string like this

$sql = "$sqlsearch1";

and I get a syntax error.

The value in $sqlsearch1 works perfectly well if it not held in a variable. I know I'm missing something but I just don't know what.

Any help would be appreciated.
Thanks

ahundiak

Why are you trying to add mysql_query to the string?

$sql = 
 "SELECT *  FROM clubs 
  WHERE checked = 'Y' AND $a LIKE '%$b%' 
  ORDER BY $a LIMIT $offset,10";
$result = mysql_query($sql,$db);

baffled_in_UK

where ???

ahundiak

Sorry. I guess I don't understand your post at all.

In your original post you had:
$sqlsearch1="mysql_query(\"SELECT * FROM clubs ... lots more stuff ...,$db)";

Unless you are planning on using eval(), I really don't see why you would put 'mysql_query' in a string. And the $db will certainly give you problems.

baffled_in_UK

maybe it's partly my fault in not giving enough information. The code before the select is :

$db = mysql_connect("localhost","pass","user") or header("Location: error.php");
mysql_select_db("value",$db) or header("Location: error.php");

the code after is:

while ($myrow = mysql_fetch_array($result))  { 
... other stuff ....  

}

Does it make more sense now ?

ahundiak

Nope. Mybe it's the accent🙂

Why are you trying to put the string 'mysql_query' into $sqlsearch1?

Are you thinking that
$sql = "$sqlsearch1";
Is somehow going to execute a query? It's not.

Do me a favor and look at your original post again. Maybe it's just a copy/paste issue.

baffled_in_UK

Are you thinking that
$sql = "$sqlsearch1";
Is somehow going to execute a query? It's not

That what I was thinking. Am I being particularly stupid in thinking that it would work ? 🙂

Is there a way I can use something like..

$result = "mysql_query[variable_string]" ;

variable string would contain the SELECT values

Thanks for your patience.

laserlight

What do you mean by the "select values"?

baffled_in_UK

SELECT * FROM table WHERE value1 = 'Y' AND value2 LIKE '%xxx%'

that sort of thing.

ahundiak

That is what I tried to show in my first reply.

/* Build your query string */
$sql = "SELECT this FROM that";

/* And then execute the query */
$result = mysql_query($sql);

/* The above line performs the same as */
$result = musql_query("SELECT this FROM that");

baffled_in_UK

Got it. Sorry for being so thick.

Thanks for your time ahundiak.