Home

Error with simple php search engine form?

Mar 16, 2009 by strawberry | Posted in Programming & Design

Hi,

I am trying to create a simple search for the documents on my website.
The sql table is documents, and the three columns i want to search are anch, desc, and pdate.

It seems to parse the value (POST) across alright

As you can see at the end of the line

desc LIKE '%test%'

(that you wrote yourself :-) DESC is a SQL keyword --it's short for DESCending... I'm pretty sure this is at least one of the things that need to be changed before

SQL Server Tutorial - Introduction to 2008 (Beginning Query lesson on Single Table Queries)

From Chapter 2.1 of Beginning SQL Joes 2 Pros (www.joes2pros.com). How to use exact criteria matches in a basic single table query in SQL server ...