How to retrive numbers from database
Posted: Tue Jul 27, 2010 6:36 am
Guys this I presume is simple but I cant get it to work for some reasons.
I want to write a query that will retrieve numbers from my table. I have retailers with first letters as numbers (0-9). My query only retrieves letters and not numbers..any help pls??
I want to write a query that will retrieve numbers from my table. I have retailers with first letters as numbers (0-9). My query only retrieves letters and not numbers..any help pls??
Code: Select all
function get_letter($letter){
$conn = db_connect();
$query = "select * from retailer where name LIKE '$letter%' GROUP BY name";
$result = @$conn->query($query);
}