Thread

I am not able to make get the following code to work in a snippet.  I set the template to allow php and parse on input.  I am not able to get the userdata call to work in the template either.

{exp:query sql="SELECT DISTINCT name
FROM purchases
WHERE name = '<?php echo $this->EE->session->userdata['username']; ?>' "}
<a href="#" class="menu_link">{name}</a>
{/exp:query}

I think my issues are with the parsing order.  Does php inside a snippet get parsed before a module tag?
Thanks in advance for helping 😊

Edit:  I am using MSM, could this be causing the problem?

Yes, I’m pretty sure php inside a snippet is parsed before a module tag.
What’s not working? Is {name} not printing or is the whole thing not printing?

Hi Stephen,
I now found out that I can not get any standard variables to work in my new site in MSM.  I think that I have missed some setting that is not allowing standard variables to work.  Example, when I use in the template {username}, it displays {username} on the webpage. 
Thanks for answering,
Dave

I haven’t done much MSM, so I’ll have to leave you to the EE folks. Sorry I couldn’t help more. Best of luck.

Thanks Stephen
THis thread can be closed as I have started a different thread.

Hey funnEE,

Closing off. Thanks Stephen for your help!

If you need anything else, please just let me know by opening a new thread.

Cheers,