Hello Peter.

I use the following code {snippet system17|ada|Monsido}

The Snippet's alias is "system17" and I send two variables, the category (ada) and the product (Monsido).

For the last 3 years this section of code in the snippet pulled ONLY those organizations that used Monsido.

$sql = "SELECT * FROM `database`.`systems_2017` WHERE `\1` like '%\2%' ORDER BY SchoolDistrict ASC LIMIT 5";

But now it seems to be pulling ALL organizations, not just the ones that use that product in that category.

I've upgraded to 3.9.1x and version 8.04 pro of snippets. I think the syntax may have evolved and I wasn't aware of it.

Can you provide any insight into why this might be happening?

The variables are being passed correctly because I can see them in other parts of the code.

What is breaking is only the synatx around the selection "WHERE"

So my new snippet should be:

{snippet alias ="system17" 1= "ada" 2="Monsido"}

????

It used to be {snippet system17|ada|Monsido}

I've tried it and it's not working. THank you for your support. Once I figure this out I can fix the site.

THis is the actual code of the snippet itself "system17"

THat worked! Peter you are a God!

Thank you Thank you Thank you!

P.S. I'm barely able to program in PHP, but your Snippets program encouraged me and pushed me to get this to work. Now I have a 1,000 member site where we discuss these various school programs and how to integrate them.

I am so very thankful for Regular Labs!

Peter, one last HUGE favor. The select code in SQL appears to stil be selecting ALL of the school districts, not just the ones with the actual value. Any other suggestions?

I'm using this snippet code:
{snippet alias="system17" key="ada" value="Monsido"}

ANd this SQL code below, but it's pulling ALL of the organizations instead of just the 6 that are using the Monsido app.

Thanks for the tip about changing source to xsource. I did, and I can see it is not passing through the second variable.


$sql = "SELECT * FROM `schoo126_sd`.`systems_2017` WHERE `ada` like '' ORDER BY `SchoolDistrict` ASC"; $result = $conn->query($sql); if ($result->num_rows > 0) { echo "

Are the double %% causing the issue? Or the use of the " ' " instead of the ' ` "?

The value is getting passed through by your snippets, because the first sentence says "School Districts in California that use "value" - and the Value is coming through. So it's just something strange about the sql code intepreting the double %% maybe ?

username: jreviews, not previews, sorry.

OK great. Thank you!!