The iHub Wish List

[stack]

Bob,

sure it has time to implement. Good things need time.

Unfortunately I don't know ASP and IHub scripting so well as to quickly pull out the necessary code here for. But I've done it for PHP/SQL and there it is quite easy. Something like this for the search display page if it helps:

$search = $_POST['search'];
$page = $page+0;

$result = mysql_query( "SELECT messageid FROM ihub WHERE name like \"%$search%\" or text like \"%$search%\" order by entrytime LIMIT $page, 10" )
or die("SELECT Error: ".mysql_error());

while ($get_id = mysql_fetch_array($result, MYSQL_ASSOC)){

$result2 = mysql_query( "SELECT name, text FROM ihub WHERE messageid=\"%$get_id%\" " )
or die("SELECT Error: ".mysql_error());
while ($search = mysql_fetch_array($result2, MYSQL_ASSOC)){
print "$search[name], $search[text]";
}
}

$page = $page+10;


of course the code is incomplete..
and so on, the basic idea, two database searches on the searchdisplaypage, the first searches all message id where string was found. the second prints the text of all idresults limited to 10 per page.

greets

s.