If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Enjoy an ad free experience by logging in. Not a member yet? Register.

RE: Why am I getting these error and warning?

The PHP code is meant to receive input from a search form. The php in the search.php file (see below) should search for the inputted text in three columns on a table: Title, Post and Date. If it finds matches, it lists only the titles of the rows in which the word being searched has been found. If the searches are many, the first twenty appear on page 1, the next 20 on page 2 and so on. If no matches are found, the php code echoes "No matches found."

I have tried coming up with the following code but it isn't working as I'd want it to. First, I excluded the Date column from the searchable areas because the code was generating errors when I included Date column. Secondly, the php is listing every title of rows in my table.

I have not understood Arcticwarrio statement that "Date is a reserved word you'll need backsticks when referencing it `date`". What am I meant to do with the Date word?