Results 1 to 3 of 3

Thread: what this error means?

  1. #1
    Join Date
    Mar 2003
    Location
    Canada
    Posts
    3

    what this error means?

    Hi;
    this is my first post here;
    I use DWMX for designing my page and
    I am beginner in php and mysql, I have made a web page using PHP/Mysql,
    and I use Mysql front as well.

    I have made a seach page using two drop down menu for search which populate data out of a DB,

    the db was working until something has been done and I don't know what, so keep getting an error, when click on submit button in search page,
    I don't think it is becaue of my php code,
    the error says:
    Unknown column 'Apple' in 'where clause'

    Apple is data, it is the name of company inside of my table,

    if i select any other name from drop down the error message is same, only the name will be replaced by the selecte one,
    where or how can I find the problem? if there is any.

    I have no idea where to start looking for a problem.
    Thanks for your reply
    Last edited by manou; 03-15-2003 at 06:32 PM.

  2. #2
    Join Date
    Feb 2003
    Location
    Johannesburg, South Africa
    Posts
    145
    This sounds like a syntax problem in your php code. Make sure you have ticks/qoutes where it should be. Make sure the variable name is where it should be.

    Cheers

  3. #3
    Join Date
    Mar 2003
    Location
    Canada
    Posts
    3
    thanks a lot, yes that was the problem,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •