nikomou
03-10-2007, 09:56 PM
Hey,
Is it possible to filter out results if the first 2 digits of a txt sting is, for example "o2" ($tariff2)?
e.g. I have a table with the data:
o2xnet200min
o2offpeak
someotherdata
moredata
evenmoredata
and i only want to show results if the 2st two digits match with $tariff2
$query="SELECT * FROM handset WHERE 1ST TWO DIGITS OF tariffid='$tariff2";
Thanks for your help!
Is it possible to filter out results if the first 2 digits of a txt sting is, for example "o2" ($tariff2)?
e.g. I have a table with the data:
o2xnet200min
o2offpeak
someotherdata
moredata
evenmoredata
and i only want to show results if the 2st two digits match with $tariff2
$query="SELECT * FROM handset WHERE 1ST TWO DIGITS OF tariffid='$tariff2";
Thanks for your help!