Code: Select all
$insert = "INSERT INTO members ('loginid', 'password', 'firstname', 'surname', 'email', 'trade', 'address1', 'address2', 'address3', 'address4', 'postzip', 'country', 'yearsexp', 'about') VALUES ...Moderator: General Moderators
Code: Select all
$insert = "INSERT INTO members ('loginid', 'password', 'firstname', 'surname', 'email', 'trade', 'address1', 'address2', 'address3', 'address4', 'postzip', 'country', 'yearsexp', 'about') VALUES ...Use backticks instead for field names, database names and table names.Mirux wrote:Code: Select all
$insert = "INSERT INTO members ('loginid', 'password', 'firstname', 'surname', 'email', 'trade', 'address1', 'address2', 'address3', 'address4', 'postzip', 'country', 'yearsexp', 'about') VALUES ...
Code: Select all
<?php
$sql = "INSERT INTO `tableName` (`field1`, `field2`) VALUES ($unquotedIntVal, '$quotedStringVal')";
?>