Unknow colum error in PHP after adding new column in MySQL
Posted: Tue Jul 18, 2006 8:23 pm
I am running a query in my php code which works fine. I added a new column to my MySQL database and populated it with values.
In the SELECT statement in the php code, I added the new value to query the new column that was added, but for some reason I am getting a database error saying "Unknown column j.app_email", and I have no idea why. I have checked all spellings and everything I can think of, so this is why I am now posting.
Has anyone ever encountered an issue like this?
Then added new column app_email to jobs
In the SELECT statement in the php code, I added the new value to query the new column that was added, but for some reason I am getting a database error saying "Unknown column j.app_email", and I have no idea why. I have checked all spellings and everything I can think of, so this is why I am now posting.
Has anyone ever encountered an issue like this?
Code: Select all
SELECT j.app_phone, j.app_fax
FROM jobs jCode: Select all
SELECT j.app_phone, j.app_fax, j.app_email
FROM jobs j