Unknown column 'Practice' in 'field list'

Hello,

I created a search and results form using the wizard. When I tru the search form I get the following:

Unknown column 'Practice' in 'field list'

Not sure what I'm doing wrong. I've attached the files. Any help would be greatly appreciated.

Thanks,

Frank

Hmmm, I dont see the cause of the problem looking at the code for the page.


to troubleshoot, find the following line:

$WADAPhysicians = mysql_query($query_limit_WADAPhysicians, $optimus) or die(mysql_error());

and change it to:

$WADAPhysicians = mysql_query($query_limit_WADAPhysicians, $optimus) or die(mysql_error()."<br />".$query_limit_WADAPhysicians);

this will write the sql to the screen along with the error to help us see what is going wrong, please post back the results or a link where we can see the issue.

unknown column 'ID' in 'field list'
SELECT ID, GroupID, Email, Password, FirstName, LastName, Phone, Fax, Country, Address, Address2, City, State, Zip, IP, EmailVerified, VerificationCode, RegistrationDate FROM users ORDER BY ID ASC LIMIT 0, 10

All are fields are in the database and the SQL line was created by DA... need direction....

It seems the problems was on the MySQL side. At the suggestion of Jason, I renamed my fields names to a 3 digit table reference with the field name (usrFirst). After this adaption I've seen no issues.

Tip for the future: use the naming convention above, as it will insure MySQL and PHP calls do not conflict with similar field names.

Thanks again WA for being there.