$variable

[juniorelnino]

$query = "SELECT area_code, location, rates FROM t_rate where location like "$countryHead%"";

The $countryHead is suppose to be an alphabet where the user click.

My initial statement was
$query = "SELECT area_code, location, rates FROM t_rate where location like "I%"";

My question is how do I subsitute all the alphabets into $countryHead. For example, when a User click on the alphabet "A', the $countryHead will be "A%"

[mukhtar2t]

peace be upon you.

> $query = "SELECT area_code, location, rates FROM t_rate where location like "$countryHead%"";

you can write this instead
$query = "SELECT area_code, location, rates FROM t_rate where location like ".$countryHead."%";

[juniorelnino]

Thanks for the help. Im relatively new to php and SQL.

[mukhtar2t]

no need for thanks we hope our god give us a good for any help that is Mohammed "Sala allah alih wasalam" said.