any suggestions - a call for php/mysql gurus

[galofre]

Does anyone know how can I fix this query, I am trying to show the cities in florida, eventually I need to create a variable for the state, so in the link will give the value to the rest of the states.

I have the following:

<table width="100%"  border="0" cellspacing="0" cellpadding="0">
  <tr>

  <td>

 <?php

$query="SELECT city FROM pycontact where stateprov=\"FL\""
 echo $query;

 ?>
</td>
  </tr>
</table>

If I want to change the variable I only add $state=state and change the query to: $query="SELECT city FROM pycontact where stateprov=\"FL\"" ???

any suggestions?
thanks

[chadu]

you should be able to do something like this:

$state = "whatever you want to set it to";
$query="SELECT city FROM pycontact where stateprov=$state";

[galofre]

I think something is missing, the page result shows blank???

is this code correct?

 
 <?php 

$query="SELECT city FROM pycontact where stateprov=\"FL\"" 
 echo $query; 

 ?>