Hello everyone.

So i got Toplist, when a search is made through search.php it checks the database and looks throught my members description, titles etc and display results on a new page.
Guess thats how its always done :P

Ok, so i know there is some way to archive this, as ive seen it before, but i got no clue how.

How could i display, lets say the last 10 made search queries in my sidebar as links?

Does anyone know tutorials about this?
I asume i would need to save the query somehow in the database, maybe?

Help would be highly appreciated,
Thanks

how familiar are you with PHP

Not that much really. I know to archieve php stuff from the script iam using, but php in general ( i guess the search things falls under it ), iam pretty useless there.

Seb

It would take some time to write a solution for you and explain it in here especially for free (I'm guessing that's what you want)

your best bet is to start learning PHP so you can build your own solutions

If you want to learn i can help or there are loads of tutorials out there

Thx mate, but i need this now, learning stuff before is nogo for now.
Allready recieved a little help from which i can go further myself.

Thanks though.

Hmm i got everything working, ( working, even though it spits out errors )

Someone know why these 2 errors show up? or how to fix it?

code

PHP Code:

$search_date = time();
$result = $DB->query("SELECT * FROM {$CONF['sql_prefix']}_search ORDER BY search_date DESC", __FILE__, __LINE__);
$rowtotal = mysql_num_rows($result);
if ($rowtotal >= 10) {
$DB->query("DELETE FROM {$CONF['sql_prefix']}_search WHERE search_date <= '$search_date' ORDER BY search_date ASC LIMIT 1");

$DB->query("INSERT INTO {$CONF['sql_prefix']}_search (search_query, search_text, search_date) VALUES ('{$TMPL['query']}', '{$TMPL['query']}', '{$search_date}')", __FILE__, __LINE__);
}

else {
$DB->query("INSERT INTO {$CONF['sql_prefix']}_search (search_query, search_text, search_date) VALUES ('{$TMPL['query']}', '{$TMPL['query']}', '{$search_date}')", __FILE__, __LINE__);
}

// End Recent Searches 


And this are the 2 errors, which are caused by the delete from line

PHP Code:

Warning: Missing argument 2 for sql_mysql::query(), called in /home/anachron/public_html/sources/search.php on line 74 and defined in /home/anachron/public_html/sources/sql/mysql.php on line 42

Warning: Missing argument 3 for sql_mysql::query(), called in /home/anachron/public_html/sources/search.php on line 74 and defined in /home/anachron/public_html/sources/sql/mysql.php on line 42 


You call DB->query with three parameters except for in once case

Try:

PHP Code:

$search_date = time();
$result = $DB->query("SELECT * FROM {$CONF['sql_prefix']}_search ORDER BY search_date DESC", __FILE__, __LINE__);
$rowtotal = mysql_num_rows($result);
if ($rowtotal >= 10) {
$DB->query("DELETE FROM {$CONF['sql_prefix']}_search WHERE search_date <= '$search_date' ORDER BY search_date ASC LIMIT 1",__FILE__, __LINE__);

$DB->query("INSERT INTO {$CONF['sql_prefix']}_search (search_query, search_text, search_date) VALUES ('{$TMPL['query']}', '{$TMPL['query']}', '{$search_date}')", __FILE__, __LINE__);
}

else {
$DB->query("INSERT INTO {$CONF['sql_prefix']}_search (search_query, search_text, search_date) VALUES ('{$TMPL['query']}', '{$TMPL['query']}', '{$search_date}')", __FILE__, __LINE__);
} 


Ha mate awsome, i didnt even noticed i forgot those file, line stuff

Thanks, working now.