As your HTML variable is a string you need to enclose it with single quotes:
sqlstring = "SELECT * from (table) WHERE (field)='" &(variable) & "'"
The fields in the MySQL database are set to NOT NULL, which means that you can't insert a '' value into them. Try altering the script to insert a single space as in INSERT INTO table (field1, field2) VALUES (' ', ' ') and see if that works. If it does, then use TRIM() to retrieve the values from...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.