5Converting from PHP Mysql statements to Mysqli statements I found myself making certain mistakes. While the Mysqli procedural style resembles the mysql style, yet if you simply convert mysql_ to mysqli_ things wont work that easily ! I will try to list the errors and the action ... ...
1Multiple like in sql query may slow down performance if not properly done ! Was using the below sql query in PHPSELECT DISTINCT col.id,name FROM col,cor WHERE seat.id=col.id AND seat.id=$sql_id AND name LIKE %$like% OR desc LIKE %$like% ORDER BY name LIMIT 0,100I was using 2 lik ... ...