pulldown value passing need help

[kjoker]

Hiya guys,

was wondering if someone can help me. I need to do a query that compares the value from a pulldown menu to the value in dbase.

Right now if I do:
$query = mysql_query("select * from $tablename", $connection);

it shows the results just fine.

But when I added WHERE pulldown = '$pulldown'"
it shows no result.

What am I doing wrong here? Is there a different code for passing value from pulldown listing?
Thanks.

[Sxooter]

You might want to post a few judicious snippets of your code enclosed by [ php ] tags (just use the php button in the editor on this site).

That said, it is likely that your variables are showing up in the $GET or $POST Arrays.

Try adding these simple lines at the top of your page that processes the form to see what's coming in:

print "GET Vars:<BR>";
print implode(":",array_keys($GET));
print "<BR>Post Vars:<BR>";
print implode(":",array_keys($POST));

So, what you need is something like

$query = "select * from sometable where somefield ='".$_GET['varname']."''";

[kjoker]

yay...learn something new today.

thank you thank you thank you thank you thank you thank you

😃

[Sxooter]

you're welcome. 🙂