number query

[tuf-web_co_uk]

i know how to query a database to look for certain files starting with certain letters but how do i do it, to work with numbers.

e.g

to show the waypoints begining with letters

i would query

$sql = "select * from waypoints where type = '$cat' AND name LIKE 'cs_$letter%'";

so it would look for files beging with cs_<then the letter>

but how do i do it with numbers

thanks in advance for any help

🙂

[tuf-web_co_uk]

ok well i tried that code

$sql = "select * from waypoints where type = '$cat' AND name LIKE '$cat_$letter%'";
$result = mysql_query($sql) or die(mysql_error());

which i said worked but it doesnt show only the 1 letter it shows the whole database.

please could anyone help

[tuf-web_co_uk]

ignore the second post i fixed it but i still dont know how to display numbers