Put the percent symbol inside of the single quotes:
$result = mysql_query("SELECT * FROM mydata WHERE name like '$begin%'
",$db);
"Naga Sean" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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]
>
--
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]
