What do these line of code do.

[deansaddigh]

1.

$search = "AND (p.propertyName LIKE '%$searchKey%' OR c.name LIKE '%$searchKey%' OR c.surname LIKE '%$searchKey%')";

 

What are the '%$searchkey%'  and why is there a p. infront of propertyName

 

 

[salathe]

The p probably refers to an aliased table name (FROM mytable p) and the '%$searchKey%' is a mixture of two things: firstly, the value of the $searchKey variable is substituted into the string (if $searchKey is blah then the string is '%blah%'), then that value is used as a parameter for MySQL's LIKE operation. See the LIKE man page.

[deansaddigh]

Thanks for your help, tis a bit complicated ill have to try and absorb what you mean.

 

Thank you.

[Maq]

This relates more so to MySQL than PHP.  Moving there.

[salathe]

If you'd like a more in-depth (baby steps) explanation, do let us know and someone will be along to help you out.