Help with PHP/MYsql and WML

ShiggyWiggy

Having some troubles so any help would be greatly appreciated.

I have a web based system that uses php/mysql.

Am now trying to set up a small part of this that can be accessed with a mobile phone.
Using php/mysql and wml to do this, have php files and change the headers to make them WML files.

Have been able to view them in a wap browser and interact with the database etc

One part is causing me problems though, I take input from the mobile user, a number and also a selection from a pull down menu.
I use these in one of my queries to display some results but I just can't seem to get it to work.

I can display their entered number and selected option by using
$(number) and $(location) but if I use them in the queries it wont work.

Is it possible to use them?
Anyone point me in the right direction or show me how to be able to use these in a query?

Thanks

rehfeld

its been a while since i wrote anything in wml, but i assume you talking about displaying the values to them, from within wml right?

you need to send that data back to your server so you can collect it w/ php. point a form back to your website. just like html

ShiggyWiggy

Sorry, i'm not really sure what you mean. Could you give me a little more information.

Think my first post probably didn't explain it too well, maybe some example code would help.
I have two files.
File 1
<?php
// send wml headers
header("Content-type: text/vnd.wap.wml");
echo "<?xml version=\"1.0\"?>";
echo "<!DOCTYPE wml PUBLIC \"-//WAPFORUM//DTD WML 1.1//EN\""
. " \"http://www.wapforum.org/DTD/wml_1.1.xml\">";
?>
<wml>
<card id="card16" title="Recommendation">
<p>
<b>Recommendation</b><br/>

Number:<input name="number" size="15" format="*N"/><br/>
Select closest location:<br/>
<select name="location">
<option value="London">London</option>
<option value="Edinburgh">Edinburgh</option>
</select>

<br/><br/><anchor>Get Recommendation<go href='recommendation2.php?number=number'/></anchor><br/>
</p></card>
</wml>

File 2

Within file 2 I have some php code that runs a query and displays the results.

In this query I need to use the values from the first file for the location and the number. The part of my query which uses these variables looks like....
WHERE closestLocation = '$(location)' AND groupNumber = '$(number)'.....

But this dosn't work

neerav

In the wml, try the anchor as:

note: 1) the parenthesis 2) second variable which wasn't sent before and 3) the ampersand as an entity connecting the two variables

and in your File 2 (recommendation2.php), have the query as:

WHERE closestLocation = '$location' AND groupNumber = '$number'

note: the absence of parenthesis in the query

I hope this helps.