How to check if field already exist in a database table.

Question

I need help please: php & mysqli code to check if username, phone number and email already exist in a table. Thanks!
https://code.sololearn.com/W3w8iJaHLl8S/?ref=app
https://code.sololearn.com/W3w8iJaHLl8S/?ref=app

Answer 1

Do not write SQL queries in Relevant Tags, instead, you should've tagged SQL, for clearer classification of the question. Those who filters the questions by tag will skip your question because it didn't tag SQL, your chances for answer has just been reduced by that.

As for your question, read the following post:

https://stackoverflow.com/questions/3395798/mysql-check-if-a-column-exists-in-a-table-with-sql

Answer 2

You're welcome, and please don't forget to edit the Relevant Tags.

Answer 3

thanks