MySQL warning of Unknown column that exists?

You have a comma after "orders o,", which means that you are trying to join the currency_master table with the users table, instead of orders and users I suppose you wanted to have: $sql=" SELECT o. *, u. User_name, u.

Email, od. Artist_id,cm. Nexchange_price FROM ".

$tableprefix. "currency_master cm, ". $tableprefix."orders o INNER JOIN ".

$tableprefix. "users you ON o. User_id = u.

User_id // et cetera.

You have a comma after "orders o,", which means that you are trying to join the currency_master table with the users table, instead of orders and users. I suppose you wanted to have: $sql=" SELECT o. *, u.

User_name, u. Email, od. Artist_id,cm.

Nexchange_price FROM ". $tableprefix. "currency_master cm, ".

$tableprefix. "orders o INNER JOIN ". $tableprefix."users you ON o.

User_id = u. User_id // et cetera.

Thank you very much! Worked perfectly! :) – Abs Jul 19 '09 at 20:30.

Perhaps tableprefix is messing you up. What is the value of variable $sql before you run the query?

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.