Problem with inserting data into mysql database
Posted: Sun Oct 11, 2009 1:51 am
Hi,Everyone
Now I have wrote a sql text for inserting some data into the database
Then i got this error message
MatchQuery failed: Unknown column '$UName' in 'field list'
you must knew that $UName is a php variable and it isn't a field in the database table called 'smf_members'
what is the wrong with mysql text ?
plz help me as soon as possible
Now I have wrote a sql text for inserting some data into the database
Code: Select all
'INSERT INTO `smf`.`smf_members` (`memberName`, `realName`, `passwd`, `emailAddress`, `address`, `phone`, `mobile`, `gender`, `signature`) VALUES (`$UName`,`$RealName`,`$Pass`,`$Email`,`$Address`,`$Phone`,`$Mobile`,`$GenderType`,`$Signature`);'
MatchQuery failed: Unknown column '$UName' in 'field list'
you must knew that $UName is a php variable and it isn't a field in the database table called 'smf_members'
what is the wrong with mysql text ?
plz help me as soon as possible