How do I get a $string into a $query = "select from where...."?

3dron

$rr = 'Bob';

Can I do something like this:

$query = "SELECT * FROM dbase WHERE pick1 = '%%%s%%'", $rr);

or something like this:

$query = "SELECT * FROM dbase WHERE pick1 = '$rr'";

Neither seem to work. I need the $rr in the $query statement because it is in a nested loop.

Please help.

RonR

liquidchild

Can you explain it a bit more, not really sure what you want to do, why do you have all the %%% in your query these are wildcards so i cannot see a use for three of them, I think you would only need one, i.e %s%, this would then return all values that contains s in them. Anyway...

3dron

OK, I guess the first is totally wrong just use the second

$rr = bob;
$query = "SELECT * FROM dbase WHERE pick1 = '$rr'";

So I am trying to get values that equal bob with $rr

How do I put a vairable in the statement?

mrblom

Thats the way to do it,

but remember to select from a table in the database...
like this

$rr = "bob";
$sql = "SELECT * FROM [your table] WHERE pick1 = '$rr'";