Search facility error

[Pinkmischief]

hi i am having a prob with this code it keeps saying Unknown column 'about' in 'where clause'

I wonder if someone could explain it for me please

The columns stated in the query are exactly as they appear in mysql front so i cant see where the unknown column is?

here is the about code

$query = "SELECT os,manu,type,version,comments,link,siteuser,sitepass about FROM drivers " .
"WHERE about LIKE '%".$keywords['0']."%'";

Many Thanks Pinky

[thephpguy]

Pinkmischief wrote:

hi i am having a prob with this code it keeps saying Unknown column 'about' in 'where clause'

I wonder if someone could explain it for me please

The columns stated in the query are exactly as they appear in mysql front so i cant see where the unknown column is?

here is the about code

$query = "SELECT os,manu,type,version,comments,link,siteuser,sitepass about FROM drivers " .
"WHERE about LIKE '%".$keywords['0']."%'";

Many Thanks Pinky

It either means the about column doesn't exist in the drivers table OR you need to put a comma after sitepass so it looks like:

$query = "SELECT os,manu,type,version,comments,link,siteuser,sitepass,about FROM drivers " .
"WHERE about LIKE '%".$keywords['0']."%'";