Getting the following error on calling search.php



Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE timestamp >= '1275346801' AND timestamp <= '1275433201'' at line 1
Statement: SELECT COUNT(id) AS hasnews FROM WHERE timestamp >= ? AND timestamp <= ?
Arguments: 1275346801,1275433201

There is no search.php in 3.6

See here

http://code.google.com/p/n-13news/wiki/Integration

Tried all the path configs including full path.
It wont run. Just a blank screen.

Show me the code you're using.

<?php
$search = true;
include ../news/index.php';
?>

<?php
$search = true;
include 'news/index.php';
?>

<?php
$search = true;
include '/home/sites/domian.com/public_html/news/index.php';
?>




etc

Hint: the search form has been moved into the templates.

If you're using an older template, like 3.2, it won't have the search form. Use Ajax 3.6 template as the default and it should work, compare the differences between it and the one you're currently using.

Thank you Chris

Ive got it....
By the way, it implements a nice list.....


Just a further question, what is the best way to get the search box directly under the article ? I tried a few ideas. Obviously it could be added in an i frame but I was hoping to put the box under article so that search stayed within same frame [no new window].

edit : sort of expected the search to added in 'news structure' ?

Currently you can't. What you can do though is add another include with $search = true specified so that the search form always shows.