View Single Post
  #1  
Old 26 Jun 2006, 19:45
LBSources LBSources is offline
 
Join Date: Nov 2005
Real name: Lenny
Question Error .. 1054 MYSQL .. Where Clause seems correct .. ideas?

This is a simple statement to draw some info on a home page regarding user stats .. right now the error i get is
Invalid SQL:
SELECT userid, username FROM myprefix_user WHERE myprefix_userid=2;

MySQL Error : Unknown column 'myprefix_userid' in 'where clause'
Error Number : 1054
I changed the prefix in this example, but the correct prefix is in the error. What exactly is it complaining about?


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

__________________
.....
LBSources

Learn About The Bronx, New York!
Reply With Quote