I am having trouble with the syntax of select. (using php and mysql
combined) The user keys in a number and I want to look for that field (only
one field can have that value as its created automaticaly upon dataentry)
Based upon the number the user keys in I want to retrieve another field from
the same record
This is not working. How do I do it?
$upgcollect='SELECT scfpwd1 FROM scfmforening WHERE scfmnum = $scfchknum';
$scfchknum is the variable the user keyed in.
scfmforening is the name of the table