• alsu
  • Member
  • Offline
  • Registered: 2014-08-27
  • Posts: 52

Topic: error in search using a date field with different database table

sir  i use two different search parameters, one is 'bookename' and other is 'bookissuedate'

and they are in two different tables like BOOK and DATE respectievly. at the time of searching i got a error msg

      "no such coloumn:   main.bookissuedate."     (i want search queiry  in bookname)?



any script?

  • Registered: 2014-02-14
  • Posts: 10,294

Re: error in search using a date field with different database table

maybe you have an error in the database structure.


Why fields  'bookename' and  'bookissuedate'  in two different tables?
There is a relationship between the tables 'bookename' and  'bookissuedate' ?

Dmitry.