I switched web hosts and I'm trying to get everything up and going. But, the queries that had worked before, don't work anymore.
If there is a variable passed, it doesn't work:
"SELECT *
FROM productions
WHERE showno = $prodvar
ORDER BY yearopen";
If I put the variable that $prodvar is set to in the query instead of $prodvar,
it works fine. So,
why is this wrong on a different server?
Thanks for the help.
Jer
