Nik,

echo ("<p>EZ#: $ez_num</p>");  does not work
echo ("<p>EZ#: $(ez_num)</p>"); does work

in a query:
"SELECT * FROM workinprog WHERE ez_num = '$ez_num'";   does not work
"SELECT * FROM workinprog WHERE ez_num = '$(ez_num)'";  does not work
"SELECT * FROM workinprog WHERE ez_num like '%$ez_num'"; does work

This wap stuff is driving me crazy.  My applications is so simply it's
ridiculous.  But I have spent hours and hours trying to get this stupid little
program to work and it just will not act correctly, (like html).  It's very
frustrating.

In winwap 3.0 there is a view of variables and I can see ez_num set to 605944,
the input value.  There seems to be a syntactical dilemma.  It seems any
variable used in or from a sql query is not working.  One thought, ez_num in the
table is a varchar field, could the input value be numeric and therefore be
valued differently then the ez_num value in the table?  Is there a way to make
sure the ez_num input on the wml car is text only and not numeric?

Does anyone have a <select> working within a wireless application?  I have tried
it a millions ways and it will not work unless I hard code the values into the
<option> statement.

Again, I want to state that I have completed the little nightmare in regular
html/php in five minutes.  I have been struggling with this wml stuff for days.
I have read every site reference possible for wml and still, I can find no
examples of php with wml that use the <select> statement.

Thanks,
Richard

Nikolai Devereaux wrote:

> // here is the problem area.
> // if I use a hard value like '605944' for example.
> // it works, buit not with '$ez_num' syntax
> $queryA = "SELECT * FROM workinprog where ez_num = '$ez_num'";
>
> Logically speaking, if your query works with 605944, and $ez_num is set to
> 605944, then it should work with $ez_num.
>
> I tend to think that there's a problem with the $ez_num variable... have you
> echoed it to the screen to see if there's anything quirky about it?
>
> nik
>