I would try two things: echo $prodvar; // to verify you are really setting it
Seperate $prodvar like this: "SELECT * FROM productions WHERE showno = " . $prodvar . " ORDER BY yearopen"; Dale --- In [email protected], "Jer" <[EMAIL PROTECTED]> wrote: > > 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 >
