It still not working I want to get the result of people with the first later is "A" in my database Here is my syntax : $result = mysql_query("SELECT * FROM mydata WHERE name like '$begin'%",$db); the $begin is from the URL link www.sample.com/name?begin=a Thanks --- "Frank M. Kromann" <[EMAIL PROTECTED]> > wrote: >wyoy could use a SQL statement like this: > >select * from myTable where LastName like "A%" > >- Frank > >> Guys, >> >> How to view the result from the table. >> If I only want to display persons begin with letter A in the front. >> >> >> >> _____________________________________________________________ >> www.kaskus.com - FREE EMAIL SERVICE >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> To contact the list administrators, e-mail: [EMAIL PROTECTED] >> >> >> _____________________________________________________________ www.kaskus.com - FREE EMAIL SERVICE -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]