Why can I query with an int but not a string here? PHP MySQL Datatypes
- by CT
I am working on an Asset Database problem. I receive $id from $_GET["id"]; I then query the database and display the results.
This works if my id is an integer like "93650" but if it has other characters like "wci1001", it displays this MySQL error:
Unknown column 'text' in 'where clause'
All fields in tables are of type: VARCHAR(50)
What…