Change the query to this:
INSERT INTO record VALUEs ('', '$name', '$email', '$mobile', '$date')
Note the absence of quotes around the table name and the trailing comma after the '$date' parameter.
The standard query format for an INSERT is:
INSERT INTO tableName (columnName1, columnName2, ...)
VALUES (value1, value2, ...)
If you are inserting data into every column in the table, you can omit the column name list, but you MUST provide values for every column in the table and in the correct order, per the table layout.