I've removed floor() and changed it to: $var = $_GET['var'];
Now I get this...modified but still similar: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE begins = 'A'' at line 4 I've tried the three different variations on the WHERE statement that you suggested and always get an error similar to above. Any other suggestions? --- In [email protected], <[EMAIL PROTECTED]> wrote: > > ----- Original Message ----- > From: "whoisquilty" > > I've got a form with a pulldown on my main page. The user chooses from the > pulldown > and that is passed to the secondary page. That variable is supposed to > search the database > and display the results. > > However, the secondary page is not getting the variable. It shows in the > URL, but it shows > as 0 in the DB query. > > <snip> > > Here's the code from the secondary page: > > > $var = floor($_GET['var']); > > <snip> > --------------------------- > floor() is a maths function so it is goint to return 0 for alpha charactors >
