Discussions of secure PHP coding. Security in software is important, so don't be afraid to ask. And when answering: be anal. Nitpick. No security vulnerability is too small.
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??
function get_letter($letter){
$conn = db_connect();
$query = "select * from retailer where name LIKE '$letter%' GROUP BY name";
$result = @$conn->query($query);
}
Last edited by Benjamin on Tue Jul 27, 2010 7:43 am, edited 1 time in total.
Reason:Added [syntax=php] tags.
Thank you manzar but my intention is not to count how many rows affected but to fetch all records that their first letters are number ranging from 0-9..e.g 999 inks
@benjamin, thanks for the reply but I stil cant get it to work. pls if you have time could u please visit my site then click on (0-9) under browse retailers. http://connektor.co.uk/vouchers/