i am working with php and trying something new that if user inputs "a" than all the records of name starting with "a" in employee table should be displayed...

sql="select * from emp where emp_name='".$letter."'* "

//is above query write and the wild character to be used is write or not
pls reply.....

Member Avatar


$sql="select * from emp where emp_name LIKE '$letter%'";

i wl try it and thn reply u again....thnx for replyng...