[SOLVED] PHP MYSQL LIKE

[anser316]

The user types something in a textbox.

e.g. s3

echo "<td><input type=text name=dname></td>";
$dname=$_POST(dname);

 

This is the end of MYSQL statement

AND dname LIKE '%$dname%'.

 

If i wanted to get 'sample3', s3 will not work, because the letters have to be together, 'sam' would work.

how can i get 'sample3' from typing in 's3'

[AV1611]

funny question...

 

like 's%3'

 

will yield

s3

sss3

ss sssss s s  s  s3

etc...

 

you can maybe explode $dname then pick the letters?

 

that would give you

array(s,a,m,p,l,e)

then maybe parse in the %

or whatever...?