I’m a newbie with mysql and php as well as this site. I came here as a last resort to find a solution to a small independent project that I’m working on.
I have a MySQL database created/filled and I’m using php to connect to the db. I’m currently working on the search feature on the site. This is new to me so I’m running into some errors.
I want to be able to input any text for search (ignoring the security risks with that at this point for testing) and have it search all the columns of the table, so basically I got stuck on the WHERE clause in the query. I know that I can use WHERE a_column LIKE “%$srchtxt%” OR another_column LIKE “%$srchtxt%” etc…
But doing this I could only put three/four OR operands after which I’ll get an error that says: " mysqli_fetch_row() expects parameter 1 to be mysqli_result.
I thought there’s a certain way to do this, so I have limited info here otherwise I can put more code/info.
Thanks for your time,