state.php?NY....

[Anon]

Hi,

Data from mysql query is displayed in a table. Also I want to click data located in one of columns to start another PHP query. But each data in column is different, how could I do that kind of PHP query? If the data is like " NY", then query is like state.php?NY.... or something like that?

thanks for your suggestions

[kparker]

NY would be the data in this case. You still need a variable name in the URL, e.g.:

&lt;a href="state.php?state=NY"&gt;>New York</a>

[Anon]

Hi,

Yes, I do need a variable name instead NY or New York. In order to let "<a href="state.php?state=NY">New York</a>" work, do you think that one array for "state" is needed before "<a href="state.php?state=NY">>New York</a>" execute?

thanks a lot

[kparker]

Probably not: on your state page, you'll automatically get a variable $state whose value is "NY".