Replies to post #875 on The iHub Wish List (IWISH)

[Burpzilla]

Quickie project... the clock on the favorites page is about 1:05 min. fast and could be re-synched.

Regards.

(You probably don't need this link, but I just happen to have it around in case it would help: http://support.microsoft.com/kb/216734 )

[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.